Skip to main content
370 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
2 votes
1 answer
84 views

I'm trying to troubleshoot a performance issue with our C# application. After investigation, the culprit is a SQL Server query that takes a long time to execute. The slow query uses an udtt (user-...
hill_piper's user avatar
  • 21
1 vote
0 answers
39 views

I have a RDL report that returns a raw Excel file with about 60 rows that took 35+ seconds to complete. The stored procedure itself (say runPNL) only takes 11+ seconds to complete. Here is the ...
Stuart Ng's user avatar
  • 11
2 votes
0 answers
56 views

Recently, I upgraded my project to use Entity Framework Core instead of Entity Framework. I have a query in my project that has recently started timing out. When I checked the profiler, I noticed that ...
GoldWoman's user avatar
  • 21
0 votes
0 answers
21 views

I'm trying to identify some slow and databases and queries on SQL Server 2008 R2. I have been able to filter by time and display the database name succefully. However the DatabaseName always says '...
danielson317's user avatar
  • 3,308
-1 votes
1 answer
2k views

This query uses a lot of CPU and takes about 30 seconds to execute. What can I do in order to improve it? The reason it uses joins is because there weren't proper relationships. I just added ones and ...
nop's user avatar
  • 6,617
0 votes
0 answers
116 views

I work with a variety of databases for work on any given day. I have built a C# tool that changes which database my system is connecting to for testing. When I change the connection details for my ...
Fuzz Evans's user avatar
  • 2,953
0 votes
0 answers
79 views

I have a session that executes 4 stored procedures. 4 is shown in sql server profiler, but only 3 is shown in Xevent profiler, -and Azure Data Studio profiler. This is the textdata from sql server ...
barnonline's user avatar
  • 327
1 vote
1 answer
989 views

I am attempting to monitor direct query from power bi on a synapse dedicated sql pool. From SSMS I was unable to log into profiler (it offered only windows and sql authentication, i am using AAD with ...
Vanessa van gelder's user avatar
  • 13
0 votes
1 answer
1k views

I have created a back end application which uses Entity framework to connect and write to the database. Suddenly I am getting the following error: SqlException: The INSERT permission was denied on the ...
user20377051's user avatar
  • 35
2 votes
0 answers
479 views

I'm running SQL Server Profiler and I'm seeing some large LINQ queries are getting truncated in the TextData. It looks like this: exec sp_executesql N'SELECT [Project91].[C14] AS [C1], [...
Eric's user avatar
  • 3,299
0 votes
1 answer
581 views

I am analysing the performance of stored procedures in an Azure SQL database, but when using the profiler in Azure Data Studio, I cannot see some of the stored procedures, specifically those that have ...
Andy McWilliams's user avatar
  • 143
2 votes
0 answers
92 views

How to change or avoid default value in SQL-Profiler call? SQL Server 2019/2017 Profiler set default values for all parameters of a stored procedure. however, It's additional and gives errors in ...
Haseeb's user avatar
  • 1,041
1 vote
1 answer
544 views

my MSSQL DB creates every second two SQL Server Profil - tace data file: How can I stop that, because we don't want to tracing something and it files my memory? My SELECT * FROM sys.traces is empty. ...
Christian29's user avatar
  • 21
1 vote
0 answers
197 views

I have XEvent Profiler in SQL Server 2016. Some articles say the duration is measured in microseconds or milliseconds depending on the SQL Server version. How do I check whether it is microseconds or ...
Summer's user avatar
  • 443
1 vote
0 answers
81 views

I have this code in visual basic calling a stored procedure: cmdr.CommandText = "EXEC [DATABASE].[USER].[BOMBA]" & cd_ponto & ",NULL," & ds.Tables("pt_col1")....
Book Writter's user avatar
  • 39
0 votes
1 answer
198 views

I want to find which database is querying from, here is my output: EXEC sp_example @stat = N'SELECT stat FROM [dbo].[statsUSers] AS [UserStats]; What I want is like this: EXEC sp_example @stat=N'...
maryam mohammadbagheri's user avatar
  • 111
0 votes
1 answer
4k views

I am using Sql server 2017 and visual studio 2019. I created a report in SSRS and initially used a stored procedure with a single parameter @Date in it and used the data explorer section to set up the ...
Betty Mcbetbet's user avatar
  • 1
0 votes
0 answers
50 views

Microsoft SQL Server 2008 - Version 10.0.6556.0 ;WITH dataAsXml AS ( SELECT xmlData.myElement.value('@myAttribute1', 'varchar(10)') AS 'myAttribute1', xmlData.myElement.value('@...
InquisitiveLad's user avatar
  • 411
1 vote
0 answers
130 views

I did search for exception 208 (invalid object name) identified by SQL Profiler and found many hints regarding "Deferred Name Resolution". Nevertheless I still did not find an asnwer related ...
SQL Tom's user avatar
  • 11
0 votes
2 answers
2k views

We are having a Power BI dataset in the service. The source of this dataset are some Azure SQLdb tables. PaaS (Platform as a Service) setup. The daily refresh of this Power BI dataset takes long. SQL ...
Ron's user avatar
  • 11
0 votes
1 answer
162 views

We trace our SQL Server activity for performance issues. Some applications, written in C#, look to have up to 50 individual spids connecting to the DB from a single machine. How can I distinguish if ...
cloudsafe's user avatar
  • 2,524
1 vote
0 answers
225 views

We are soon to migrate our back-end from an Amazon SQL Server RDS to another identically set up RDS server. We intend that our systems will not be interrupted because they connect using an AWS alias ...
cloudsafe's user avatar
  • 2,524
0 votes
1 answer
294 views

I am trying to correlate SQL query activity in a SQL Server Studio profile trace with different client processes in a large application that I am new to. The connection ApplicationName column in the ...
camelCase's user avatar
  • 1,840
0 votes
1 answer
659 views

I have an exe written in Delphi a decade or more ago, with no source code. It calls a ms sql database, maybe more than 1 to retrieve data. I have read only access to one of the databases, I don't have ...
David's user avatar
  • 5,557
-1 votes
2 answers
740 views

I have inspected EF Core 6 through SQL Server Profiler which is shocking from a performance point of view. Here nothing profiled which is very good: var user = App.Ctx.LoginUsers; This code nothing ...
Sanjeeb's user avatar
  • 11
0 votes
1 answer
1k views

I am using SQL Server Profiler 2019. My "Not Like" filter on "Application" is not working. It is still getting values for "SQLAgent". See values below. How do I exclude ...
mattsmith5's user avatar
  • 1,357
0 votes
2 answers
56 views

We had a performance issue with one of our queries in our application that was taking 20 seconds to run. Using azure data studio we figured out the SQL that was long running and then eventually ...
Jaydel Gluckie's user avatar
  • 328
1 vote
1 answer
154 views

Say you have a excel file containing a cube(referencing a Multidimensional cube on a SSAS server) configured such that you have a hierarchy in the rows: And this hierarchy has been expanded so that ...
David Rogers's user avatar
  • 2,743
0 votes
0 answers
67 views

I need to configure Profiler to save logs from an Analysis Server and save this data to a table on SQL Server daily. The problem is that every hour it stops working. How do I configure it correctly to ...
Nilton Henrique's user avatar
  • 1
1 vote
1 answer
127 views

I am working on a solution to this ticket, as part of that I'm analyzing various types of MDX queries from various sources. I've noticed that we you intercept a MDX call from a cube in excel connected ...
David Rogers's user avatar
  • 2,743
0 votes
0 answers
31 views

If a software application uses Entity Framework Core (3.1) and connects to Microsoft SQL Server (2019) for data, in the SQL Server Profiler, we see it is listed as "Core Microsoft SqlClient Data ...
JoyfulPanda's user avatar
  • 1,077
0 votes
0 answers
457 views

I have wondered if there is an easy way to obtain the SQL from a SQL Server Profiler trace session into a single SQL script file? At present I do these steps: Open SSMS and the database of interest, ...
Allan F's user avatar
  • 2,346
1 vote
0 answers
989 views

I am trying to copy the trace file information to SQL table with fn_trace_gettable function, but while running this function I am getting 'Trace file name is invalid'. And I confirmed the path and ...
DeoBelbert's user avatar
  • 13
0 votes
0 answers
166 views

I have entire script in SSMS (I'm using the version 2014) and there I use parameter @EmployeeID which contains hundreds of Employee_ID (int, not null). If I choose only 1 Employee_ID, then is OK, but ...
JohnB's user avatar
  • 21
0 votes
1 answer
43 views

I have a performance issue caused by a latency in return from the Repository 's Get method . var res = Data.TicketRepository.GetSingle(filterExpression, includeNavigations); So i configured a ...
A.HADDAD's user avatar
  • 1,917
2 votes
0 answers
673 views

I am running a trace against a SQL Server database that I have that makes extensive use of stored procedures. I have noticed that in some cases, when executing a stored procedure, the RPC:Starting and ...
David Keaveny's user avatar
  • 4,190
9 votes
1 answer
19k views

Scenario: User logged in to desktop using domain account User has an Azure account in AAD which is different from the domain account Azure SQL database with AAD authentication configured for the ...
mark's user avatar
  • 63.7k
1 vote
1 answer
247 views

I get this query in sql profiler SELECT [r].[OfficialFactorId], [r].[AllowCalcTax], [r].[AndicatorNumber], [r].[BasketId], [r].[BookDateTime], [r].[CalculatedWithUserCurrency], [r].[...
farhad's user avatar
  • 85
2 votes
0 answers
196 views

I am using SSIS job to process the ssas DB(cube, dim, partition etc) in source server and XMLA script in the same SSIS package to synchronize the SSAS DB from source server to destination server. This ...
ScriptSoft's user avatar
  • 183
0 votes
0 answers
339 views

Which profiler trace template can be used to see the table type parameter values that are passed into a stored proc ?
codingIsCool's user avatar
  • 86
2 votes
0 answers
263 views

I am using SQL Server 2016 in Windows. There are multiple connections to SQL Server and a database. Each of those connections have a Session Context Key 'CustomerId' and a specific value. So for ...
Syed's user avatar
  • 27
0 votes
2 answers
170 views

I wrote this left join in LINQ and I only selected PersonId from SHPerson table, but in SQL Server profiler, I got PersonId from SHPFA table too. var spfQuery = from n in shHPFARepository.GetAll() ...
hussein zakizadeh's user avatar
  • 173
1 vote
1 answer
115 views

I was running a trace and found something that I don't understand. I have a procedure with a simple select statement that returns the first non-null value from a sequence of function calls. I would ...
EduardoCMB's user avatar
  • 504
1 vote
0 answers
499 views

Now I am trying SQL Server Profile. There new trace has been created and filter- TextData like 'select%'. It is running fine with output saved on SQL table. I got required query. Beside I notice ...
Pugal's user avatar
  • 549
0 votes
1 answer
397 views

We've got a rogue process running somewhere that executes queries against a test database we have hosted on Azure SQL. I'm trying find this process so I can kill it. There are a number of app ...
JohnPloskina's user avatar
  • 1
0 votes
1 answer
379 views

I want to record all SQL statements that hit my server to replay it later. But it seems that neither SQL Server traces nor events do capture the insertion of large data chunks into binary columns. I ...
sandimschuh's user avatar
  • 55
3 votes
1 answer
3k views

I want to use TextData Like filter in the SQL Server profiler with multiple conditions to filter queries that contains any of the words. I have used OR conditions but it's not working. How can I use ...
Sumit Shitole's user avatar
  • 130
0 votes
2 answers
375 views

In .Net framework I use MiniProfiler for MySql connection command logging. In my current AspNetCore solution MiniProfiler doesn't show sql commands as well. What MiniProfiler options I should be using ...
Valery Yegorov's user avatar
  • 311
0 votes
0 answers
152 views

We're verifying legacy system in SQL Server 2000 and confirmed we can connect it from SQL Server Management Studio 2016 (Need to add TCP port though). Now we'd like to connect SQL Server Profiler ...
Sachiko's user avatar
  • 964
2 votes
1 answer
2k views

I have a huge SQL server database. I want to re-write an application. For that I want to reuse the database which has many tables, views and stored procedure. I am using SQL Profiler tool to map the ...
richa verma's user avatar
  • 297

1
2 3 4 5
…
8