SQL server on Hyper V performance

Posted on 2012-09-04
Last Modified: 2012-09-24

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
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.

Question by:isonali
    LVL 20

    Accepted Solution

    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.

    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

    Author Comment


    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 ??


    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Viewers will learn how the fundamental information of how to create a table.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now