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 |
|
ijprasad
Starting Member
29 Posts |
 Posted - 2005-08-08 : 07:13:17
|
| Dear Friends,I am using Sql-Server 7.0.We have the Database of 550GB and it was working fine from last 6 years. One week back its become very slow. queries which used to take 2 to 3 minutes now it is taking 30 to 40 minutes.We have defined the proper indexes on each table. We have only one MDF and one LDF file. At this stage I cann't afford to segredate the MDF or LDF file. Please help us in this regard. How can I improve the performance of database. How can I find the statistics of database? what happened to the database?Inderjeet |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-08-08 : 10:34:05
|
| Have you used DBCC Showcontig to check your indexes?Have you checked the query plan to see if it is the same as before?DanielSQL Server DBAwww.dallasteam.com |
 |
|
|
|
|
|
Database Performance