March 26, 2007 at 9:08 am
I support a third party app for which I don't have any control of the development aspect of the system. There are certain modules that the end user will use that causes the disk queue length to stay at a steady 75-100 counter on the logical drive where my data files reside. I am not getting the response back from the vendor that I was hoping for. Would adding additional memory help in this case? Right now I have 8GBs on the cluster with 7GBs allocated to SQL. or would a poor running query cause this spike and I am at the mercy of the vendor?
March 26, 2007 at 1:14 pm
- run sqlprofiler to find out what is going on.
- maybe adding an index solves this problem
- splitting to filegroups and moving a filegroup to another disk may also solve your problem.
Start with the sqltrace using profiler!
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 26, 2007 at 1:20 pm
Thanks. I found it was an indexing problem with their app. All is good now.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply