Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tooba
Posting Yak Master
224 Posts |
 Posted - 2013-01-31 : 23:03:05
|
| 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
52326 Posts |
Posted - 2013-02-01 : 02:43:20
|
| are you running it directly on server or are you running it from remote computer? where are you storing the trace?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-02-01 : 13:18:06
|
| 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.htmlTo 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 approachJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
tooba
Posting Yak Master
224 Posts |
Posted - 2013-02-02 : 00:10:30
|
| I am running from Remote Computer.... I want to trace it down why application is getting slow. |
|
|
|
|
|
|
SQL Profiler