SQL Server 2005 Slow Performance

Welcome, guest Sign in | Your Profile | Help

HOME

YOUR DASHBOARD

CONNECTION DIRECTORY

SQL Server Home Downloads Feedback Surveys

SQL Server 2005 Slow Performance by Govindaraj

Active

Type:	Bug
ID:	508955
Opened:	11/7/2009 1:08:28 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Thesql server 2005 is very slow for specific time duration particulary between 2 PM to 4 PM. It is caused even only very limited user connected. The server specification is IBM X-226 series (Xeon Processor, 2 GB RAM, 140 GB Hardddisk)

Details (expand)

English

SQL Server 2005 SP1 - Workgroup Edition

SQL Engine

Win2003 Enterprise Server (SP1)

English

SQL Server 2005 in windows server 2003

Performance is very slow between 2 - 4 PM even very limited user.

All time the performance should be same.

0 attachments

Posted by Microsoft on 11/20/2009 at 4:53 PM

Govindaraj,

We don't have enough information to understand this issue from your initial description. It could be a larger number of possible things that may involve application design, SQL Server, or both. In this forum, it's important that you narrow down the issue by providing a detailed way to reproduce the problem. If you need additional help, consider contacting Microsoft Consulting Services (for design help) or Product Support Services (if you think the problem is a bug).

Best regards,
Eric

Posted by Sankar Reddy on 11/22/2009 at 5:23 PM

Govind,

For issues like this you will get better responses if you post this in the forums. As Eric mentioned there could be lot of factors that could be causing. SP2 and SP3 fixed lot of issues and you may want to look at those options too. Please feel free to post in here (http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads/) and one of us will pick up from there.