Hi I am running SQL Server 2000 (ent edition) on windows 2003. My server is running slow but task manager shows that cpu performance is low, like 20%. There are no locks, I still have 21gb left on my disk. All the files for All the DB's are set to unlimited growth. Can anyone tell me what should I look for in profiler or somewhere else? Thanks TA
use the sp_now function. see my post: http://sql-server-performance.com/Community/forums/p/8496/48114.aspx#48114 It will show you what is running on your server at that time and what is being slow, etc. I would also try a quick sp_updatestats and see if that helps!