SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 SQL Profiler
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tooba
Posting Yak Master

195 Posts

Posted - 01/31/2013 :  23:03:05  Show Profile  Reply with Quote
Hi Guys,

Quick question, I am running SQL Profiler against my 2008 database. My question is what should i worry about (i.e High CPU, High Reader, High Duration?

Please guide me,
Thank You.

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 02/01/2013 :  02:43:20  Show Profile  Reply with Quote
are you running it directly on server or are you running it from remote computer? where are you storing the trace?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2076 Posts

Posted - 02/01/2013 :  13:18:06  Show Profile  Visit jackv's Homepage  Reply with Quote
Check for blocking , and analyse the blocking statements - try and optimise these statements. The Blocked Process Report is set up through SQL profiler - read for details http://www.sqlserver-dba.com/2012/10/sql-server-find-queries-causing-lock-timeouts-per-second.html

To define what you need to look at , understand the nature of the queries - and that way you can define the searches. For example, if it's an OLTP and the expectation is queries will talke 1 second - then Duration maybe a good approach

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

tooba
Posting Yak Master

195 Posts

Posted - 02/02/2013 :  00:10:30  Show Profile  Reply with Quote
I am running from Remote Computer.... I want to trace it down why application is getting slow.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.73 seconds. Powered By: Snitz Forums 2000