May 20, 2010 at 10:47 am
Hi Folks,
I need to do some monitoring on the production Temdb. Can somebody please help me with it?
I need to do the following-
Check the current tempdb size
Determine the frequency of tempdb growth
Determine the optimal tempdb growth rate to reduce wait times due to db growth
Setup a maintenance plan to truncate the tempdb as needed to control the size and balance this with the information gathered in the first 3 items
Thank You
May 20, 2010 at 11:19 am
http://technet.microsoft.com/en-us/library/cc966545.aspx#
[font="Courier New"]ZenDada[/font]
May 20, 2010 at 11:20 am
Here is another option.
http://www.sqlservercentral.com/articles/Log+growth/69476/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 2:39 pm
Thank you for your help so quick Zen Dada.
May 20, 2010 at 2:39 pm
Thank you so much Jason. This looks awesome.
May 20, 2010 at 2:43 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 3:53 pm
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply