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%.
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 ?
forgot the sql server img
is working on a reply...