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 |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2003-09-26 : 12:09:13
|
| Hi,We are seeing probems with using @resample for following 2 scenarios:1) We run the update statistics for all tables using syntax: update statistics table_name with sample 20 percent We have daily nightly script that runs exec sp_updatestats @resample='resample' so as expected it is doing update statistics daily with 20 percent sampling ratio Later we want to change the sampling ratio to 30 percent so we run following command for all tables: update statistics table_name with sample 30 percent But our nighly script instead of using 30 percent sampling ratio is still using 20 percent2) Since the data is growing with time, we expect @resample to use sampling ratio based on current rows in system but it is using sampling ratio based on time when we run update statisics manually. For example if today table has 10000 rows and we run update statistics with 20 percent; @resample we do update statistics for 2000 rows but if number of rows in table increases to 20000 rows we expect @resample to do 4000 rows but it is still doing 2000 rowsIs there any bug in using @resample or we are not doing right way?Thanks--Harvinder |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-26 : 12:32:10
|
| Maybe you need to run DBCC UPDATEUSAGE(DBName) to correct any inconsistencies.Tara |
 |
|
|
|
|
|
@resample problem