MS SQL 2008 on Hyper-V

Posted on 2011-10-17
Last Modified: 2012-06-21

Is there a difference of running SQL 2008n on Hyper-V.  I noticed that the indexes become fragmented very fast (in minutes).  Is this normal?  I am not sure how to prevent the indexes from becoming fragmented.  Is there something that I can do about it?

Thank you for all of your help in advanced
Question by:thomasm1948
    LVL 7

    Accepted Solution

    Actually there is no relation with Hyper-V and index fragmentation. The index fragmentation occurs faster if the write operaions (insert, update,delete etc.) increases. To prevent this you should check what is updating your tables. You can use SQL profiler to see what is going on. Instead of preventing, you can use index rebuild/reorg jobs to freshen the indexes.

    Author Closing Comment

    That makes sense.  Thank you for all of your help

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Suggested Solutions

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video discusses moving either the default database or any database to a new volume.

    733 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

    19 Experts available now in Live!

    Get 1:1 Help Now