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 |
|
MFlanagan
Starting Member
10 Posts |
 Posted - 2012-03-28 : 11:41:43
|
| I have a situation that I am puzzled by. I have a server that has for years hummed along processing roughly 200 transactions per second with 10 compilations per second on average as well. CPU utilization was always in the 5-10% range.Now as of this past Sunday at about 10:30PM our Transactions per second has jumped to 3000 per second and Compiles 100 per second. CPU has gone to an average of 40%.Now I am fully aware that high transactions per second is normally a good thing but I am confused about what may have caused the huge jump? We made no changes to the box or our application that would explain this. I am wondering if something has caused each statement that is submitted to spawn a larger number of transactions? We reviewed statements submitted to the box and there is no increase in the number of statements submitted - just a 10X increase in the number of transactions per second with corresponding increases in CPU and Compilations...So any suggestions on where to look to see what is responsible? If the box is just magically working faster that is one thing - if it is just working harder for some reason, that is another. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-28 : 11:57:26
|
| what was activity that was happening in box at that time? was there some bulk data population happening?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
MFlanagan
Starting Member
10 Posts |
Posted - 2012-03-28 : 12:08:46
|
| There was no one process that we ran at that time. And to clarify - The averages I listed above have maintained their increased values since that time. I have a graph of the Transaction/sec from the first of the year until today and it runs along the bottom until this past Sunday where it jumps to the 3000 per second level and has stayed there since.I have looked to see if there was any process stuck running that would explain it and have found nothing. It just looks like all of a sudden the box is processing 10X as many transactions a second with no increase in the number of statements being sent to the box. |
|
|
|
MFlanagan
Starting Member
10 Posts |
Posted - 2012-03-30 : 09:05:11
|
| Anyone have any suggestions as a course of action to pursue? This is more of a "What has changed to cause this?" rather than a "Something is wrong - fix it!" I just don't like having something occur on one of my servers that I cannot explain - regardless if the result is positive or negative. |
|
|
|
MFlanagan
Starting Member
10 Posts |
Posted - 2012-04-04 : 08:54:50
|
| Still hoping that someone can give me some ideas on how to research this. Again - I am not overly concerned about the metric being "bad", I just want to be able to identify what could have caused such a drastic change from one day to the next... |
|
|
|
|
|
|
Transactions per second