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 |
shireef.adel
Starting Member
4 Posts |
Posted - 2008-07-22 : 11:10:40
|
After a period our database was in production it slowed down , We make a lot of tunning.Now we have a testing server we put a copy of the production database (full one) , the perfomance is better , BUT when we use a new empty database on the same server the performance slower than the huge one!!!!we have made some reaserch and experiments like the follwoing:1- delete all indexes from the empty database.2- make the two databases on the same physical diskbut nothing we have.plz any ideas?There is no God, But Allah and Mohammed is his Prophet |
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-07-22 : 12:36:27
|
"1- delete all indexes "....that's one good way to slow down any database. |
|
|
shireef.adel
Starting Member
4 Posts |
Posted - 2008-07-22 : 18:12:48
|
i made that to try if alot of indexs may affect the performance of queris specailly Insert in the Empty database.our measure is to insert 1000 files data (rows) in reasnable timeit takes 4 mintutes in large database and 10 minutes in very small database and empty database whitch should insert this number in no time.do u have any explanation for this?There is no God, But Allah and Mohammed is his Prophet |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-22 : 22:21:03
|
>> 2- make the two databases on the same physical diskAnother good way to slow down dbs. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-07-23 : 03:13:34
|
We'd need to see sample code and sample table definitions to move beyond this really... |
|
|
shireef.adel
Starting Member
4 Posts |
Posted - 2008-07-27 : 03:30:27
|
the same code run on both databases they are on the same test server but we switch between them for testing and measurment.we made our tunning from a period of time on the large database, and it become more suitable.but when we test our changes on the same database after deleting all data the performance slowed down again!!!I cant find an explanation for thisThere is no God, But Allah and Mohammed is his Prophet |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-27 : 15:03:17
|
Did you update statistics after deleting data? |
|
|
shireef.adel
Starting Member
4 Posts |
Posted - 2008-07-28 : 07:37:16
|
ya, but i did update states command on all the data base ,is there a differnce between using it and updating state for each of the critcal tables separetlyThere is no God, But Allah and Mohammed is his Prophet |
|
|
|
|
|