October 20, 2009 at 7:37 am
After I have changed the file settings like size, growth etc on TempDB a few weeks ago, I still do not see the refreshed data when I right click on TempDB, and do properties->Files
Neither am I able to see the settings in tempdb.sys.database_files.
I am sure if I restart my SQL Service, it should refresh out, but is there any other way to see the latest/current settings for TempDB.
For example, we had changed the growth settings on TempDB from None to 10%, but it does not reflect on it there, and I know it grew this morning, and that is another proof that growth was turned on last month, but I cannot see that in the settings; it still says no autogrowth allowed.
thanks
Dan.
October 20, 2009 at 7:45 am
How did you change the settings? In SSMS and the current settings are not shown?
If you check sys.database_files, what do you see in there? zeros?
October 20, 2009 at 7:53 am
I changed the settings through Alter Database commands. But when I see through SSMS or sys.database_files, it is not reflected. Growth is zero in sys.database_files
October 20, 2009 at 8:00 am
It is good to take tempdb in your control.
you should find traces of your operation in the default trace of your instance.
- can you provide @@version info of your instance ?
These are the refs I use:
http://support.microsoft.com/kb/187824
http://support.microsoft.com/kb/224071
http://www.tech-recipes.com/rx/2342/sql_server_2005_move_tempdb/
- "Concurrency enhancements for the tempdb database"
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en (shorter story)
- Working with tempdb in SQL Server 2005", paragraph "tempdb size, including the right number of files and file size",
http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
- related to max_degree_of_parallelism ? http://support.microsoft.com/kb/329204/ (only if needed)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 20, 2009 at 9:26 am
ALZDBA
I using Microsoft SQL Server 2005 - 9.00.4035.00 (SP2).
October 20, 2009 at 9:44 am
did you receive messages about databases that couldn't be opened due to insufficient resources or disk space ?
I have this occasionally on my laptop, and then I don't trust what the system tells me.
After a stop/start of the instance everything works back as expected.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 20, 2009 at 9:56 am
No, I did not have any insufficient disk space issues.
Did you notice it only with your laptop DB or all Dbs?
October 21, 2009 at 12:37 am
I only noticed this on my laptop, which is becomming slow, so I'm not surprised this may occur because of timeouts.
The instances on my laptop (sql2000 / sql2005 / sql2008) are only for personal test purposes.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 21, 2009 at 4:50 am
HI repent_kog_is_near,
Hope you are using SERVICE PACK 3.
check using select serverproperty('productlevel')
October 21, 2009 at 6:10 am
yes, SP3;
sys.database_files still has zero for growth, even though today, also the TempDB grew!
I am hoping to find a way to do this, without restarting the SQLService.
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply