February 12, 2010 at 2:05 pm
sql 2003 sp3
am i missing something or just going crazy.......
I've setup a sql profiler to run on the pretty busy server
using standard template with filter (databases name = tempdb)
and i see no activity what soever......can this be ?
what is the best way to see tempdb activities?
also tempdb data has been split between 4 equally sized files....
is there a way to see activity per tempdb file?
Thank you.
February 12, 2010 at 2:20 pm
Why do you think there is more activity on TempDB? Is there any specific reason? Most of the time TempDB activity is high during Rebuild index job or Back up jobs, only thing you need to make sure is you take TempDB log backups consistently so that log space will not grow and use all disk space.
EnjoY!
February 12, 2010 at 2:43 pm
it should be busy.....
we have plenty of 'group by', joins, 'order by'...
also i did rebuilt a few indexes with 'sort in tempdb 'option for few databases.....
see no activity in tempdb
????
February 13, 2010 at 6:24 am
profiler reports the database where the transaction originates.
so unless someone was actually USING tempdby a la:
use tempdb
go
it won't show up.
Cheers!
Craig Outcalt
February 16, 2010 at 6:23 am
great point, SQLBOT!
Thank you
February 16, 2010 at 8:32 am
only thing you need to make sure is you take TempDB log backups consistently so that log space will not grow and use all disk space.
GT You can't backup tempdb.
You could look at the Sort Warning event, can be found under errors and warning in profiler...It doesn;t include index rebuilds but does indicate sort operations that do not fit into memory.
Gethyn Elliswww.gethynellis.com
February 16, 2010 at 8:36 am
This link maybe helpdul too:
Gethyn Elliswww.gethynellis.com
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply