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 |
|
vasanthhepsy
Starting Member
48 Posts |
 Posted - 2007-12-03 : 01:36:49
|
| Hello,Earlier,As there is no tecnical / Syntactical errors existing and was perfectly running the report earlier and yielding the result in quick time.But my Application running well earlier and If I execute the SP or report for which It takes more time what would be the consequences and what and where I should do and begin to see the problem.Thanks for your time and reply. |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-12-03 : 03:09:25
|
| i'm really not clear what you're asking. can you rephrase it? or is there someone that can maybe help you with your english?Em |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-12-03 : 03:24:30
|
| You will need to look at execution plan and IO statistics first to identify the cause of the problem.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2007-12-03 : 17:15:36
|
| There is also the issue of parameter sniffing.Here is one article about it: [url]http://nflanagan.blogspot.com/2006/07/parameter-sniffing.html[/url] |
|
|
|
vasanthhepsy
Starting Member
48 Posts |
Posted - 2007-12-03 : 18:26:56
|
| Thanks for the replies so far.It is basically what I thought but double checking apart from the reply to look into : IO Statistics and Execution Plan.Is there any other parameters that I can consider at the bottom level.Once again thanks for your answersVasanth |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-03 : 22:17:24
|
| Cpu usage and network throughput. |
|
|
|
|
|
|
Peformance Tuning / Trouble Shooting