Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dpais
Yak Posting Veteran
60 Posts |
 Posted - 2009-07-16 : 15:28:18
|
| Hi Gurus :We have a MS SQL Server 2000 Standard Edition (32 bit) running on Windows Server 2000 via VMWare on an Opteron AMD Processor. We have 3.5 Gigs of RAM alotted to the Windows server but SQL Server being Standard Edition caps the memory to 2 gigs. (is there a way around this ?)In the last 6 months we have grown from a 10-15 user Implimentation to a 75-80 user interface of which 25 users are considered superusers i.e using the system and Processor for more than 80% of the day.Load on the server is typically algorithms because we run 2 Advanced Planning and Scheduling Engines and 2 MRP engines daily. My datawarehouse is 5 Gigs and will be doubling our size in the next 3 months. All users are more comfortable with our setup and are using the system through Delphi Forms created by a Thick Client that we develop and Administer.I KNOW THE SERVER IS CHOKED FOR RAM ... AND MAYBE PROCESSOR SPEED - but I am finding it difficult to proove it to Management.Please advise how i can show the RAM as being in-suffecient and Processor too slow.Is there any way around the SQL server 2 gig Cap ?? or is Upgrading to SQL 2005 the way to go ?Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-07-16 : 15:33:22
|
| Oh and upgrade to 2008, I wouldn't bother with 2005 as you'll be out-dated as soon as you upgrade.Also, has anyone done performance analysis via SQL Profiler to determine if there are missing indexes, bad execution plans, long-running queries, etc...? How often do you update statistics? How often do you run DBCC INDEXDEFRAG or DBCC DBREBUILD?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
|
|
|
Calling all SQL Team Gurus !