Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Batch Requests/Sec with Low-ish CPU spikes Expand / Collapse
Author
Message
Posted Tuesday, June 18, 2013 8:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 6:43 AM
Points: 8, Visits: 35
I am running SQL Server 2008 R2 (64-bit) standard on a Windows 2008 64-bit server. I typically notice during work hours that our "baseline" Batch Requests/Sec will fall in the 200-500 range. Lately I've noticed that we've had spikes that consistently fall in the 1500-2000 range for about 2-3 minutes where it will then level off again to the 200-500 range. This morning I actually noticed a brief spike to 3000-4000, then dipping to the 1500-2000, and now currently back intot he 200-500 range.

When the batch requests/sec spikes the CPU usage does increase, but not much. Most of the time the CPU never gets about 20% usage for the sqlserver process. There doesn't seem to be any performance issues when these batch/req increases happen, but I would still like to know how I can find what is causing them.

I have run some queries on sys.dm_exec_sessions and sys.dm_exec_connections but don't see anything abnormal when comparing low batch/sec periods vs high batch/sec periods. I would appreciate any input to find out where all of these requests are coming from. Thanks.
Post #1464708
Posted Wednesday, June 19, 2013 5:24 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:03 AM
Points: 1,380, Visits: 2,708
A SQL profiler trace during this time should point out what's happening during the spike.
Post #1465083
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse