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 |
|
sam_varg007
Starting Member
8 Posts |
 Posted - 2002-03-19 : 17:00:08
|
| Hi The jobs in my sql server database are running very slow. If I call the same proc from query analyser its runnning fast. Is there any way to find out why this happen.SAm |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-03-20 : 07:42:53
|
| SQL Profiler should be a starting point for any investigation. Maybe something different is holding up your jobs....like table/database locks which aren't present at the time of executing the code via QA.Profile both methods of execution and compare Profiler results....this will at least remove the above as a possibility, or point to a possible solution.Others may enhance this viewpoint more eloquantly. |
 |
|
|
|
|
|
jobs running slow