Sunday, February 14, 2010

SQL Profiling

As we were encountering some performance issues, I wanted to investigate some sub-optimal queries. First help is always the SQL profiler that can help you monitor your live database and give some advice based on the captured results.

But the profiler failed to run on the selected database. Some research revealed that you need some extra permissions to get a profile session up and running.

Execute therefore following script on your database:

   1:  USE master
   2:  GO
   3:  GRANT ALTER TRACE TO username;
   4:  GO

No comments: