Link to home
Start Free TrialLog in
Avatar of malraff
malraffFlag for Ireland

asked on

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!

ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of malraff

ASKER

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 -

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
Avatar of malraff

ASKER

our sql is 2005 os is 2008

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