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 |
|
Kristen
Test
22859 Posts |
 Posted - 2010-11-25 : 19:20:26
|
I could do with some help trying to fathom out why our server is getting to a tipping point.If you have some time available (needs to be Friday and/or over the weekend) and could help please drop me a PM. Needs to be folk who I've known on this forum for at least a year please. (We can sort out Invoice or case(s) of wine/equivalent.)Thanks  Details of the issue are here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=153373 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2010-11-26 : 22:22:07
|
post ddl, sample data, and expected results.
elsasoft.org |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-11-27 : 06:38:03
|
I'm tempted to  |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2010-11-29 : 15:09:34
|
| Where is the bottleneck when it hits the wall? Memory (Buffer or Windows) what is PLE normally, and what is it when it hits the tipping point? Disk? What is typical Disk Latency, what is it when you hit the tipping point? Processor, what is normal/abnormal?? Once you ID the bottleneck, you can dive deeper into what is causing it, and perhaps alleviate it.-Chad |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-11-29 : 20:10:06
|
| Thanks Chad. The Perf Monitor stats are here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=153373&whichpage=2#603398Trouble is I don't see anything that indicates that it is resource bound. We have significant contention for something, but all locks are releases promptly - its just that we can't satisfy all the customers that "walk in the door" but we have Memory, CPU and Disk to spare ... |
|
|
|
|
|
|
Optimisation Help