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

Tempdb workfile creation/sec is high Expand / Collapse
Author
Message
Posted Friday, September 06, 2013 7:49 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 6:57 PM
Points: 81, Visits: 333
I have alert mails from SCOM which indicates the counter workfile creation/sec is high. When checked its going above 38.
Tempdb is not growing.
I have SQL 2K8 Ent. 64 bit 8GB Memory for sql.

My doubts are bleow.

What is the value for workfile creation/sec to be worried?
How should I dig deep into to check what is causing this?
Post #1492246
Posted Monday, September 09, 2013 12:23 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 4:38 AM
Points: 6, Visits: 90
This counter indicates the number of work files created per second. Workfiles are used in processing hash operations when the amount of data being processed is too large to fit into the available memory.

there is no fixed threshold for this counter. You should compare it with a baseline. To reduce this number, you should tune the queries, review indexes and add memory if required.


Prashant
Check out my blog at http://sqlactions.com
Post #1492663
Posted Tuesday, September 10, 2013 6:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 6:57 PM
Points: 81, Visits: 333
Thanks.
I am going to create missing indexes on the server.
Post #1493143
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse