November 25, 2013 at 4:21 pm
Hi,
I have noticed that the CPU usage is increased by 15 % after installing CU 8 for SQL Server 2008 R2 SP2.
Does anybody experienced this? are there any known issues with CU8?
Thanks
November 25, 2013 at 4:32 pm
I have not experienced anything yet. Did you check to see what wait types you are having? CXPacket or SOS_SCHEDULER_YIELD? If so, have you identified those queries. It is possible that execution plans may have changed also, have you checked if Parallelism is happening (execution plan)?
November 25, 2013 at 4:34 pm
Nothing is changed in the application except CU8 installation. From last few weeks the CPU usage is <25%. But today, CPU usage is 40 % most of the time.
November 25, 2013 at 4:51 pm
Okay. What are the Max Degree of Parallelism and the Cost Threshold values for the server? Is it for OLTP/Datawarehouse/OLAP? I know that service packs shouldn't change those settings, but take a quick look.
November 25, 2013 at 5:30 pm
Hi juancabrer, do you have SQL Server 2008 R2 SP2 CU8 in your environment?
fsaagent waittype is the top wait type. It's OLTP environment. MAXDOP is 1.
November 26, 2013 at 8:26 am
Mani,
I am not sure if you have been able to figure it out yet. I believe that you will see the FSAGENT wait type whenever you are using FILESTREAMING/SQL BLOB. Do you have FILESTREAM Access level enabled? (check under server advanced properties). That specific wait type has a value of zero on my servers because I don't have FILESTREAMING enabled.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply