Skip to Content
0
Feb 17, 2009 at 08:33 AM

SQL server performance tuning-tempdb

450 Views

Hi All,

We are using SQL Server 2005 .The tempdb size has grown and second thing is that sqlser.exe as checked in Task Manager is taking around 41% CPU and memory utilization is also high.

Can anybody let me know how can I clean up tempdb ,as we don't want to add one more log/data file.

Also ,what should be done to fine tune the SQL performance.

Hope to hear from you soon.

Thanks in Advance

=============

Ajay