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?