I am running a SQL Server 2014 Standard Edition (Cumulative Updates 6) instance on an r3.large Amazon EC2 box. I noticed that the CPU usage of SQL Server skyrockets to 100% while executing pretty much no queries at all.
Looking at the SQL Performance Tool, I can see that most of the time is lost in SQL CLR functions.
Here's a screenshot of one of such operations: http://ift.tt/1M5yeHD
Most of those CLR functions are doing basic things. For example the IsNullOrEmpty function is returning the result of String.IsNullOrEmpty() but even those are taking up between 1500 to 7000 ms to execute.
If I take the same job and run it on a physical box that we use for development, those calls can't almost be seen as they're way too quick.
Is there anyone who faced similar issues? I suppose it's due to EC2 or VMs but I can't really tell why. Thanks!
Aucun commentaire:
Enregistrer un commentaire