September 24, 2008 at 8:16 am
Hello, I was wondering if you could help me. I get Message alert that tempdb is full, so as far as I understand I need to add more space for tempdb,bit I don't know if I am doing right:
My temp tempdev: is 8MB and templog: is 1MB. My largest db is 630MB. Can I change from 8MB to 500mb and from 1 to 258 (20%) than biggest db, is this correct?
Here is my setting for temp DB:
DBSize Unalocated size
tempdb 9.00 MB 7.22 MB reserve data index_size unused
800 KB 248 KB 384 KB 168 KB
tempdev
PRIMARY 8192 KB Unlimited 10% data only
templog
NULL 1024 KB Unlimited 10% log only
Also, do you usually do use unrestricted file grows or restricted, if restricted how do you run by? Can I changed settingis anytime of tempdb or I have to restore SQL Server?
September 24, 2008 at 1:09 pm
Read this... http://sqlserver2000.databases.aspfaq.com/why-is-tempdb-full-and-how-can-i-prevent-this-from-happening.html
Regards,
[font="Verdana"]Sqlfrenzy[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply