Guest Jay Posted July 10, 2008 Posted July 10, 2008 Hi, I have a Windows 2003 Server with no major software, just MS Office and MS SQL Server and no antivirus software too. It is a standalone machine and it has an SQL database with 500Mb of data and a procedure that takes a a few hours to run. This machine has a 3 GHz CPU and 1028MB RAM. Thing is that I have another Windows XP Workstation with SQL Server Personal Edition, 2.8 GHz CPU and 512 MB RM. However, my process takes 1/2 the time to run on this workstation. The Harddisks are both IDEs => The controller on the workstation is "Intel 8280...Ultra ATA Storage Controller" I am not sure about the Server. Why would this be??? Some suggestions on what I can do to improve speed on the server? Thanks.
Guest Pegasus \(MVP\) Posted July 10, 2008 Posted July 10, 2008 Re: Why is my server slow? "Jay" <jay6447@hotmail.com> wrote in message news:c3feee68-a942-432d-8c61-2ad40faf7909@d1g2000hsg.googlegroups.com... > Hi, > > I have a Windows 2003 Server with no major software, just MS Office > and MS SQL Server and no antivirus software too. It is a standalone > machine and it has an SQL database with 500Mb of data and a procedure > that takes a a few hours to run. This machine has a 3 GHz CPU and > 1028MB RAM. > > Thing is that I have another Windows XP Workstation with SQL Server > Personal Edition, 2.8 GHz CPU and 512 MB RM. However, my process takes > 1/2 the time to run on this workstation. > > The Harddisks are both IDEs => The controller on the workstation is > "Intel 8280...Ultra ATA Storage Controller" I am not sure about the > Server. > > Why would this be??? Some suggestions on what I can do to improve > speed on the server? > > Thanks. The CPU clock speed is only a small part of the story. The speed at which a PC performs depends on many other factors such as CPU architecture, cache, bus speed etc. etc. I would repost this question in a hardware group to get a more detailed answer.
Recommended Posts