i have a SQL production server that has started to get quite slow when using various parts of the front end application. Tasks that used to take a second to commit now take 5-6 seconds.
Can anyone advise on
1) good general steps on performance analysis
2) any features/configs to look out for that may be enabled that cause performance issues
3) anything server specific that i could change etc
i am running sql 2005 on server 2003 ent