Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

MS SQL 2008 on Hyper-V

Hi,

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
0
thomasm1948
Asked:
thomasm1948
1 Solution
 
mozculluCommented:
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.
0
 
thomasm1948Author Commented:
That makes sense.  Thank you for all of your help
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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