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