Post by gulaschbaronen on Dec 16, 2009 6:21:29 GMT -6
Hi
Yesterday we had problems with a sharepoint content database.
We noticed it by the high cpu utlization on the database and
end Users complaining about the site was running slow.
When I ran sql profilertool i noticed some big querys that took 20 sec or more to to execute.
The querys started with (select top 2147483648)
After some hours of troubleshooting I decided to run SP_UpdateStats on the content database that the big querys was running against.
After that the problem was gone ;D
I run sp_updatestats on that database every sunday and I started to notice this problem on monday.
So what I cant understand and what my question is about:
what in sharepoint can change so much from one night to another so the SQLServer statistics is totally messed up ?
Is there someway to see in sharepoint if there has been any big changes during the past days?
Cant find anything special in eventlog of the frontendservers.
Im not that used to work in sharepoint so any suggestions to look in applogs or something similar is appreciated.
Yesterday we had problems with a sharepoint content database.
We noticed it by the high cpu utlization on the database and
end Users complaining about the site was running slow.
When I ran sql profilertool i noticed some big querys that took 20 sec or more to to execute.
The querys started with (select top 2147483648)
After some hours of troubleshooting I decided to run SP_UpdateStats on the content database that the big querys was running against.
After that the problem was gone ;D
I run sp_updatestats on that database every sunday and I started to notice this problem on monday.
So what I cant understand and what my question is about:
what in sharepoint can change so much from one night to another so the SQLServer statistics is totally messed up ?
Is there someway to see in sharepoint if there has been any big changes during the past days?
Cant find anything special in eventlog of the frontendservers.
Im not that used to work in sharepoint so any suggestions to look in applogs or something similar is appreciated.