Skip to content
April 25, 2011 / kiranpatils

Basics of SQL Profiling

Last week I was reading article on SQL Profiler from Sitecore Scrapbook and its really great document for all those who are new/already know how to use Sitecore Profiler.  The one problem it has is that it has been uploaded as .doc and few people avoid to download and then read the document. So, I thought to create a web version of the same document. So, those few people can take benefit of document.

1. Start SQL Profiler from SQL Server Management Studio > Tools

Choose File > New Trace

Check Show All Columns

2. Choose Column Filters and set e.g. DatabaseId to a specific database

2.1 No idea, what is your Database ID? No worries, you can check using following way (Find the database id from Databases > System Databases > Master > Views > sys.databases)

3. Or filter e.g. by all requests taking more than 100ms.

4. Save the trace to a database table by checking the “Save to Table “ checkbox below. Then Choose Run to start profiling.

If you liked this article then credit should go to, its original Jesper Jørgensen – article writer.

Source : http://sdn.sitecore.net/Scrapbook/SQL%20Profiler.aspx

Happy SQL Profiling! 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: