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?
 
chapmandewCommented:
No, turn it off.
0
 
uscshaggyCommented:
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.