Database running slow

[eoghan07l]

Are there any simple checks i can run to find out why a database is running slow. i checked the server and it is really badly fragmented so i am currently running a defrag on it, but i am wondering if there is anything i can run at a db level.
thanks for your help

 

[PDreyer]

update statistics
reorg rebuild
showplan

See:

Performance and Tuning: Basics
Chapter 13: Indexing for Performance

Performance and Tuning: Monitoring and Analyzing
Chapter 3: Using Statistics to Improve Performance
Chapter 5: Using set showplan
Chapter 7: Tuning with dbcc traceon

 

[eoghan07l]

i've checked the server that holds the database devices, and the drive is very badly fragmented, i have tried to defrag the drive but it will not defragment the large database Device files, so the drive remains fragmented?