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 |
|
mpraju24
Starting Member
1 Post |
 Posted - 2012-01-16 : 08:19:59
|
| I have table where RowId (INT) Identity (1,1) column. Till the row Id reaching 793500 it is working fine, but after 793500+ it started taking time to load data. It is taking almost a 60 sec to load data.Could any one suggest the solution? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-16 : 10:11:46
|
| Does the table have any indexes created in table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2012-01-16 : 11:31:45
|
| If not done recently Rebuild the Indexes and update Statistics.If not done recently, and database is in FULL Recovery Model, take a Log backupOther possibility is that the Data file is having to be extended and you have a very small extension-size configured (or, for that matter, a very large extension-size! like 10% on a database that is already very large - if so use a more reasonable size and set as a fixed-MB size and not a percentage) |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2012-01-16 : 12:15:01
|
| Its relative, isn't it? "Used to be OK" ... "Now too slow" |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Taking 55sec to load data into a table