SQL Profiler Questions and Answers

Recent IT Questions

1 - 3 of 3
<<PREVIOUS 1 NEXT>>

SQL Server Profiler's TextData Column Has NULL And Longest Duration value

My Profiler's TextData Column Has NULL value and Longest Duration value (100000ms). What could be the reason? Thanks

View Answer   |  Jul 29 2009  12:25 AM GMT
SQL Server 2005, SQL Profiler, SQL Server Profiler
asked by Jsql

  140 pts.

How to enable a trace for SQL Server Analysis Services using T-SQL?

Hi I want to enable a trace on analysis services Filter only the errors and notifications log them in a table and send a mail. I am right now doing using sql profiler, but i dont want to do this using profiler as i have to log on the server continuously. I need to do this in T-sql like an SP or a...

Answer Question   |  Dec 2 2008  9:27 AM GMT
T-SQL, SQL Server administration, SQL Server 2005
asked by GIG

  240 pts.

SQL Server 2000 (Performance Trace)

Hi All, I have a job which is running since last 6 months. The job was taking around 2-3 hrs to be completed. However, for the last couple of weeks, its taking more than required time (Max-26 hours)and we have to kill the job for users to acces the database. I am not able to find any clue to it....

View Answer   |  Dec 8 2005  9:56 AM GMT
SQL Server 2000, SQL Server performance, SQL Profiler
asked by bakash

  0 pts.

1 - 3 of 3
<<PREVIOUS 1 NEXT>>