Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance and dead lock
Message
From
14/01/2014 06:31:28
Thomas Ganss (Online)
Main Trend
Frankfurt, Germany
 
 
To
13/01/2014 17:30:29
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01591801
Message ID:
01591824
Views:
46
This message has been marked as a message which has helped to the initial question of the thread.
>The monitoring team reports that SQL server appears to be under-utilized. They say that the disk I/O is higher than the previous environment and it has been confirmed that CPU power is similar. They report however that the database is not fully utilizing the available RAM. Only half of it is presently being utilized. So, they are wondering if this could be the bottleneck.

Make sure that such measurements are taken inside the VM, not on the base host HW. Make sure that disc is at least a dedicated VHD or similar file if not mapping to separate partition or dedicated HW.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform