Enterprise Manager Hangs trying to show TEMPDB properties

Hi there -

I am trying to look at TEMPDB properties in Enterprise Manager but it just hangs forever. I can look at props for all other databases on that server OK. The server is working OK but users reporting performance problems.

Also, how to increase the size of TEMPDB in T-SQL - I can see it is approx 200MB plus 300MB for the transaction log at the moment.

(Microsoft Windows 2003 Std Edition SP1, SQL Server 2000 Std Edition SP3)

Thanks for helping,

Michael

Hi Michael,

Are you trying to use Enterprise Manager on the database server, it is probably a busy box.

You can increase the size of the tempdb by using the the alter database comand.

Code Snippet

ALTER DATABASE TEMPDB MODIFY FILE (NAME=TEMPDEV, SIZE =1000MB)

GO

ALTER DATABASE TEMPDB MODIFY FILE (NAME=TEMPLOG, SIZE =1000MB)

GO

Jag