question

Rizwan avatar image
Rizwan asked

To calculate the Tempdb utlization by query

Some of the queries causing the tempdb full. I need to know how much space is use by query. So that I can tune the query.
sql server 2008 r2tempdbquery-tuning
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Sule avatar image
Sule answered
This article will be useful for you: [ http://sqljunkieshare.com/2011/12/03/tempdb-space-usage-capacity-planning-performance-tuning/][1] [1]: http://sqljunkieshare.com/2011/12/03/tempdb-space-usage-capacity-planning-performance-tuning/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rizwan avatar image
Rizwan answered
Thanks. Its very good article .
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.