maint plan degrade the perfmon
-
I have noticed that after assigning maintainence plans , my overall db server performance is degraded.I have scheduled all the maintainence plan in the night hours only.but still i m experiencing performance problem
-
This was removed by the editor as SPAM
-
did you also perform sp_updatestats, dbcc updateusage and dbcc freeproccache (so newly generate plans come in).
Maybe it's time to use profiler to capture load and analyze it to check if you have the right (clustered) indexes.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I'm fairly sure this is a duplicate post that has already been answered
-
duplicate posts ...... 
Thanks for the notification
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply