[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

SQL server on Hyper V performance

Hi,

I installed SQL server on Hyper-V VM basically to be be used for datawarehousing

I am trying to look at the perfmon counters and trying to figure out the performance
of this vm. I see a huge number relating to wait stats and not sure what that could be.
We have a full load scheduked at 5 am in ther morning and then an hourly incremental
load.
Attached is the recorded counter values of the VM.
Also i am new to scom 2007 r2 ,i am trying to figure out how i can monitor performance of this VM on scom server ,

Please advise.

Thanks
Perfmon-VM.xls
0
Sonali P
Asked:
Sonali P
1 Solution
 
Marten RuneCommented:
You have a massive amount of Diskactivity, that seems to be related to pagesplits, line 3 in your excel sheet. I would suggest you try and adress this issue first. If you havent read up on fillfactor, now is the time to do so.

This:
http://msdn.microsoft.com/en-us/library/aa933139(v=sql.80).aspx
is an old link, but still valid. SQL performance is often about reducing disk I/O, not always but often.

From your excel sheet this is my first thought. Start here, and after you created a decent fillfactor on your clustered index, redo the measurements and see what effect it gave.

Remember a fillfactor thats high, will cause pagesplits, but a fillfactor thats too low, will demand more I/O since the data has blank spaces in it. So how to balance is a try and measure, try some other value and measure and so forth.

But in your case I would definetly look at the fillfactor to reduce pagesplits, given that these waits are your problem.

Regards Marten
0
 
Sonali PDatabase AdministratorAuthor Commented:
Hi,

Thanks for your reply.

This server is primarily used for datawarehousing.
There are five different databases which is getting replicating on this server and
then data gets extracted from these databases with help of stored procs and loaded to DW database .
I have already set a fill factor of 80 on this server.
Should i reduce it further ??

Thanks.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now