SQL 2005 Performance and Requirements

[madman045]

Currently have a 2003 standard running 2005 enterprise, 1.86Ghz Quad, 2GB Ram, 2x80Gb Raid 1 (this is not my server before anyone asks )

Now it hosts a DB for 50 Users, but only about 25 use it at anyone time.

These are the stats in task manager

Would you say it needs a higher spec at all?

Would it perform better on 64bit OS and SQL?

Thanks

 

[VeNT]

god knows, upgrade anyway! everyone wants 8GB of ram and server 2008 64bit!

 

[akakjs]

Can't tell from that lot

Fire up a performance counter log recording the physical disk, memory, process, and all the SQL objects run it for 24 hours (will need a gig or so). When you review the log, check for high amounts of paging from the SQL process, long disk queues, or long spikes for CPU usage.

akakjs

 

[brendy]

run perfmon and log disk queues and memory stats.
Speaking of new stats, I was over in our Chorley office last week installing our new quad core ml370 with 64bit 2003 enterprise with 32gb ram, I dont think chuck norris could stop this thing. (obviously there are bigger and better, but nothing runs as well as a fresh install!)

 

[Stelly]

we run 2005 server on a lot less than that with about triple users

Stelly

 

[J1nxy]

One thing to remember when looking at SQL is that it jumps on as much memory as you put in the box unless you configure it to a given threshold.