Question about SQL VM

What's a good ratio of processing power allocated to the SQL RDMBS / Server OS?

One of our VM's we crash data on was set to 90% database and 10% server allocation. It was dog slow, is this normal?

Just wondering.

Find more posts tagged with

Comments

UniqueAgEnT

90/10 sounds alright, but that really depends on the amount of processors and RAM you have. What do you currently have in total on the VM (cores/RAM)?

blargoe

We usually leave 2GB for the OS unless it's some kind of app/SQL combo server.

N2IT

My contract is over so I have no way of finding out to be honest they probably wouldn't of told me. It was very SILO'd there.

Anyway thanks for the follow up from both of you.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of