Why is my server slow?

[Guest Jay]

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\)]

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.