January 19, 2005 at 10:25 am
I need to expand the size of my tempdb due to an ASP report filling it up. The tempdb does not have it's own database device, log is shared with data and I am not sure where to start. I believe it is residing on the master database device which I have expanded. Any help would be appreciated.
Thanks
This is on SQL 6.5 BTW
January 20, 2005 at 4:01 pm
Since this v6.5, the first 2 Mb of tempdb by default are on the master device. Based on how large you want to grow it you will have to add another device first (using the 'disk init' SQL command). Next alter the tempdb to expand it's combined data and log onto the new disk device you have created. That should get you a bit of breathing room to allow you to build a case to upgrade to a supprted version of SQL server. A couple of additional points. Not knowing the size of your tempdb, nor the actual ASP report size, it's hard to say whether or not the actual report has some issues with it as well.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
January 21, 2005 at 12:37 pm
I am sure there are problems with the ASP report as it has numerous loops for each given section of the report. The tempdb is the default size of 2MB from the original installation so that also has some bearing on the script not completing. Thanks for the input.
January 21, 2005 at 1:20 pm
Creating a new device and expanding it to the device seemed to do the trick. All I need to do is up the SQL driver timeout and it should be cake.
Thanks again!!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply