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 |
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
 Posted - 2013-06-07 : 15:24:46
|
| SP shows 9 seconds in duration column on SQL Profiler. However when I get the SP and run it on SSMS it takes less than a sec.Anyone can explain why the difference? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-07 : 15:30:04
|
May be parallizing. Set MAXDOP=1 and try again, just for testing purposes. See how many cpu's you have usingSELECT cpu_count FROM sys.dm_os_sys_info |
 |
|
|
|
|
|
SP slow in SQL Profiler but fast on SQL Server