What is the CRM VM configured with for RAM? If SQL is taking up 1.2 to 1.5GB of RAM, it wont give that back to the OS unless it's under some pretty extreme pressure, even if SQL itself doesnt need it. It could be that your CRM app needs to use RAM outside of SQL and doesnt have enough depending on how much RAM the VM itself has available to it and also your min/max memory settings in SQL. Just a thought.
- Andy O. ________________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 06, 2008 9:03 PM To: NT System Admin Issues Subject: RE: Outgoing SQL Express Sorry, over the past 3 months the usage on this application has grown significantly. Its their CRM app. The SQL server always is pegging 1.2 to 1.5 Gb of memory. Since its physically limited to 1GB of buffered memory I am thinking that perhaps its bottle necking there. The DB is sitting on a ISCSI Netapp box that is basically just a file server, for a 10 office network running Exchange and SQL. There are 12 drives in the array and the monitors on it are not showing any IO bottlenecks. The servers are sitting on a ESX box running W2k3 Sp2 Image. Nothing else is really slow at all, just the CRM app and only when are all actively working in it. 10 users.. I am looking for some type of numbers of reporting that can justify purchasing SQL 2005 Std and possible some more Ram for ESX to throw another VM up. Does that help?? Thanks Greg From: Michael B. Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 06, 2008 9:50 PM To: NT System Admin Issues Subject: RE: Outgoing SQL Express Tell us how you have reached that conclusion. Regards, Michael B. Smith MCSE/Exchange MVP http://TheEssentialExchange.com From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 06, 2008 9:43 PM To: NT System Admin Issues Subject: Outgoing SQL Express Can anyone recommend how to determine if we have outgrown SQL express. We have not outgrown the DB size, but I think the single processor and memory usage is slowing down processing? Any tips? Thanks Greg ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
