sql performance

on our sql 2005 server i noticed that windows indexing is enabled on all the drives - should this be enabled? - it sounds like something that would slow things down to me when you consider the amount of transactions going through the system!

malraffAsked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
No, turn it off.
0
 
uscshaggyConnect With a Mentor Commented:
It's generally not recommended to have the indexing service enabled on servers, unless you are running some application that requires it (but I can't think of one that would).  So I would recommend disabling it.
0
 
malraffAuthor Commented:
cheers guys, always good to be able to check on here!

we seem to having quite high cpu usage since me moved to a new sql 2005 instance on server 2008

so if you have any other advice/tips let me know -

0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
chapmandewCommented:
interestingly enough...there is a bug in 2008 with lock escalation that could have potentially increase your CPU and memory usage.  

http://sqlblog.com/blogs/adam_machanic/archive/2009/10/30/sql-server-2008-lock-escalation-inserts-and-a-potential-bug.aspx
0
 
malraffAuthor Commented:
our sql is 2005 os is 2008

but cheers anyhow!
0
 
chapmandewCommented:
ah, gotcha.  In that case...who knows!  :)
0
 
chapmandewCommented:
My guess is maybe you have a new 2008 service on that you didn't have on the 2003 server.
0
All Courses

From novice to tech pro — start learning today.