Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
 Posted - 2004-09-02 : 19:51:12
|
| Apart from inefficient sql queries what may be the reason of poor database performance.Thanksmk_garg |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-02 : 19:54:52
|
| Hardware bottlenecks, bad database design, too many indexes (affects modifications), not enough indexes (affects reads), fragmentation, old statistics...Tara |
 |
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2004-09-02 : 19:57:52
|
| Apart from database design, how i can check for other things?Thanksmk_garg |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-02 : 19:59:55
|
| Performance Monitor would be used to check for hardware bottlenecks. sql-server-performance.com is an excellent resource for using this tool. For indexes, well you'd have to manually analyze things. Fragmentation would be DBCC SHOWCONTIG. Fragmentation is fixed with DBCC DBREINDEX and DBCC INDEXDEFRAG. But DBCC SHOWCONTIG displays the fragmentation level.Tara |
|
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2004-09-02 : 20:19:46
|
| Fragmentation level i can check any time or i should do it when many people are not using it.which one we should run first DBCC DBREINDEX or DBCC INDEXDEFRAG.Thanksmk_garg |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-03 : 01:47:19
|
| I believe Tara has a blog on this. http://weblogs.sqlteam.com/taradMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2004-09-03 : 02:28:11
|
| I have seen thatblog.I guess i should read all posts.Thanksmk_garg |
|
|
|
|
|
|
Database performance