Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
influent
Constraint Violating Yak Guru
367 Posts |
 Posted - 2011-05-19 : 19:30:21
|
| I saw the thread below but it doesn't help me. I'm having a CPU issue with my SharePoint 2010 database in SQL 2008 R2. Several times per day it gets pegged between 95 and 100%. It doesn't matter what indexes I use because the queries that appear to be causing it are coded by Microsoft to use specific indexes (in particular AllUserData_PK) and I don't see any way to override it. I've tested the queries (they just grab list data) using my own indexes and they use 20,000 times less CPU than Microsoft's versions according to SQL Sentry. I've played around with the server-wide maxdop and it runs best set at 1. The server is a virtual machine with 2 quad-core CPUs.[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=123584[/url] |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-20 : 01:45:00
|
| Do note that if you add indexes to a sharepoint DB, you lose all support from Microsoft it.--Gail ShawSQL Server MVP |
 |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2011-05-20 : 11:51:00
|
| Thanks Gail And Tara. I removed the indexes once I was pretty sure what the problem was, not that they were used anyway. |
|
|
|
|
|
|
SharePoint 2010 and SQL 2008 R2 cpu pegged