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

Execution Contexts - way to examine? flush? Expand / Collapse
Author
Message
Posted Friday, July 16, 2010 7:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 9:31 PM
Points: 8, Visits: 85
Hello,
We've had performance issues with our server. We typically get 'insufficient resources' error and eventually wind up rebooting the server.

I've been trying to use perfmon to see what in SQL Server is not normal.

At this time Execution Contexts (SQL Server Cache Manager) is just over 4 billion. I've seen it below 1000 when the system was rebooted and monitored it for that day... no major fluxuation.

So at this point I've tried flushing caches per non-system DB and it doesn't seem to have an effect.

Any suggestions are greatly appreciated (aside from jumping off a bridge) :)

-Peter
Post #953879
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse