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 |
AdamWest
Constraint Violating Yak Guru
360 Posts |
Posted - 2011-03-28 : 09:34:18
|
to measure performance is profiler 'enough' to get sufficient exact times some sp is taking? |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-03-28 : 10:13:04
|
Profiler is indeed the tool. Be careful using it on busy production servers though, it can severely affect performance.--Gail ShawSQL Server MVP |
 |
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-04-15 : 15:48:15
|
if you are using SQL Server 2005 and later then use SELET ST.TEXT,SP.* FROM SYS.SYSPROCESSES SPCROSS APPLY SYS.DM_EXEC_SQL_TEXT(SP.SQL_HANDLE)order by CPU descThere are available built-in reports TOP CPU TOP IO etcRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA |
 |
|
|
|
|