March 30, 2010 at 12:33 am
Hi,
In our server when i issues SP_HELPDB its showing 6766.69 MB as tempdb size and when i checked the file size from database properties its showing .mdf=8 and .ldf=1.
Please help
March 30, 2010 at 4:02 pm
Is this still an issue?
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
March 30, 2010 at 10:25 pm
The Database Properties page is showing the default size for tempdb. This is the size the files will be created as when tempdb is created after the SQL Server service is started.
When the system is in use tempdb will expand as necessary (as defined in the database properties regarding increments and maximum size). It is this expanded size that is being reported by sp_helpdb, whereas the Database Properties page continues to display the default size.
March 30, 2010 at 10:30 pm
One thing I forgot to mention.
If tempdb is growing to be much larger than the defaults then it is recommended that the defaults be changed so that it is built to the required size at the start rather than continually expanded over time.
March 30, 2010 at 10:53 pm
Another thing on if the tempdb is growing unexpectedly and is growing rapidly. I outlined some methods to find the root cause of those growths. You will need to find the root cause and correct it.
The article on the topic is 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
March 30, 2010 at 11:32 pm
Thanks a ton Glen & Jason..
March 31, 2010 at 9:26 am
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply