March 1, 2011 at 8:56 am
Hello,
I have problem with the performance of my SQL Server 2008 r2 server. When checking processor activity on the server I noticed a "heartbeat" in processor time for the sqlserver.exe process. After doing some furthur research using the performance monitor I noticed the SQLServer:Transactions object Transactions item seems to cause the heartbeat as the two lines run almost identical in the chart.
My problem is that this object and item are the only ones showing this behavior. I've checked the Transactions/sec and Active Transactions from SQLServer:Database and Transactions from SQLServer:General Statistics, however nothing seems to match.
The reason for the search of course is that we have a high performance server, but only 30 users. The heartbeat really slows the performance of the server however, so I'm desperately looking for a solution. Attached is the image of the heartbeat.
Any ideas?
Best regards,
Peter
March 1, 2011 at 9:37 am
Hello,
Found it! It seems SSRS is responsible for this. The Transactions/sec on the ReportServer databases are showing the exact same line as the heartbeat.
Regards,
Peter
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply