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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 performance in huge database is faster than in Emp

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 disk


but 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.
Go to Top of Page

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 time
it 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
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-22 : 22:21:03
>> 2- make the two databases on the same physical disk

Another good way to slow down dbs.
Go to Top of Page

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...
Go to Top of Page

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 this

There is no God, But Allah and Mohammed is his Prophet
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-27 : 15:03:17
Did you update statistics after deleting data?
Go to Top of Page

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 separetly

There is no God, But Allah and Mohammed is his Prophet
Go to Top of Page
   

- Advertisement -