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 |
|
nirene
Yak Posting Veteran
98 Posts |
 Posted - 2010-05-17 : 01:10:46
|
| Hai All, We use SQL Server 2000 as our DB, we had a new problem from 14/05/2010, in SQL Server 2000 we have about 10 database only when using one database in acts very slow it has about 3 lakh datas, what could be the problem any inputs for the rectification. Thanks in advanceNirene |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-05-17 : 02:03:37
|
| 300000 in a single table or the whole database.Also what is the actual size of the DB?PBUH |
 |
|
|
nirene
Yak Posting Veteran
98 Posts |
Posted - 2010-05-17 : 02:08:03
|
| Only one transaction file holds 3 Lakh records, all others are master file which has only a few thousand records, to add to this point we did shrink the database on 14th is that the cause.Nirene |
|
|
|
Sachin.Nand
2937 Posts |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-05-17 : 09:04:57
|
| Doing a shrink of the database will adversely impact any indexes you may have, rendering them potentially useless. You can try rebuilding the indexes and LEAVE the database size alone (indexes will increase the db size). No more shrinking, especially if this is a production database (I personally wouldn't do it on dev either, but that's me).Terry-- A word to the wise ain't necessary - it's the stupid ones that need the advice. -- Bill Cosby |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Slow Performance