question

Govindaraj avatar image
Govindaraj asked

SQL Server 2005 Performance Slow

Hi, Sql server 2005 performance is very slow between 2 to 4 PM even though very limited user logged in. It is working fine in other times. The server specification is IBM server X-226 series (Xeon Processor 3 GHZ (Dual), 2 GB RAM, 140 GB Hard disk and windows 2003 SP 1 ). It is very useful if you send any solutions to solve the above problem.

Thanks

S. Govindaraj.

sql-server-2005performance
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kristen avatar image
Kristen answered

If there are no more users logged in than usual maybe you have some scheduled task running (index rebuild or some other housekeeping task?) or some external process is performing a bulk data import or similar.

You could probably find what tasks are running using Performance Monitor

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.