High SQL Server CPU usage after SharePoint 2013 Preview install

So I was fiddling around with SharePoint 2013, and everything on my workstation seemed rather slow. I checked the task manager and my SQL Server was consuming so many CPU power, like all the time.

Task Manager_High_SQL_Server_CPU

Checking the resource monitor didn’t show much, so I had to dig down deeper. I fired up my SQL Server Management Studio and copy pasted the following query:

SELECT *
FROM sys.dm_exec_requests a
OUTER APPLY sys.dm_exec_sql_text(a.sql_handle) b
WHERE session_id > 50
and session_id <> @@spid

When you check out the text column, you’ll see lots of queries being executed like “CREATE PROCEDURE”.

sql query results

If you check the ULS logs you’ll see a lot of “slow queries” and when you check your SQL logs, you’ll see lots of warnings about insufficient memory available and that paging slows down your queries. Well, it does. If you’re on a “low memory” machine (I’m running on a virtual machine with 6GB) it’s best to give your SQL server some air. Navigate to your SQL Server properties:

sql server properties

Configure a minimum amount of memory (default is 0):

sql server memory

And boost your SQL Server’s priority:

boost sql priority

Advertisements

2 thoughts on “High SQL Server CPU usage after SharePoint 2013 Preview install

  1. Confirmed on a nearly identical setup, you solution worked for me. SQL server 2012 definitely likes to have more memory available than 2008r2 on small servers

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s