September 18, 2009 at 4:55 am
Hi,
I need to find a way to analyze a tempdb, as i would like to answer the following questions:
- Allocation per Database
- Allocation per Session / User
- Top n Statements which caused allocation in tempdb
Is there a way to do this?
Thanks!
To
September 18, 2009 at 5:37 am
September 18, 2009 at 5:50 am
tobe_ha (9/18/2009)
Hi,I need to find a way to analyze a tempdb, as i would like to answer the following questions:
- Allocation per Database
- Allocation per Session / User
- Top n Statements which caused allocation in tempdb
Is there a way to do this?
Thanks!
To
Quite a big subject, as suggested you can use the system DMV's, or you can use the performance dashboard reports to see a snapshot. if you want to try and target specific allocation using tempdb, you can use profiler to monitor tempdb activity.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 18, 2009 at 8:48 am
ok, thank you so far. I already tried to find proper DMV's but did not succeed. The intention of my post was to get some tsql samples as I think, such questions must have already occured to many dba's. 🙂
September 18, 2009 at 8:52 am
The below link may help you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply