Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Aug 17, 2012 @ 14:27
    Rasmus Fjord
    0

    Deleting a property on a media item makes my DB go nuts

    Hey Guys 

    We just switched host and im experiencing some wierd wierd issue. When im deleting a property on the "folder" media item our DB goes from 0% cpu usage to 100% in 1 sec.

    this image of the database is takin just seconds after a full SQL server restart.

    Ive done it on our local development server and it just works like normal. So its not an umbraco problem. 

    Its a brand spanking new sql server its only running 2 solutions. the server is : 

    Microsoft SQL Server Web Edition (64-bit)

    Its saying if i inspect the exe plan on one of the "expensive" queries that its stuck on some "cluster index" with a 100%.

    Any server ninjas out there ?

     

  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Aug 17, 2012 @ 14:28
    Rasmus Fjord
    0

    forgot the sql server img

Please Sign in or register to post replies

Write your reply to:

Draft