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 |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2012-08-10 : 08:03:29
|
| Dear allwe have created ssis Packages.SQL Agent job for Loading(incremental&fullRead) the data from source(ORACLE) to Destination(SQL SERVER 2008 R2).Some of the Tables having more than 15 Crore data. and some of the tables having 70 lakhs of dataEvery day loading more than 200 tables from source to destinationMy Ssis pacage Structure is 1.trucncating Tables 2.Droping Indexes 3.Loading Data (Tables) 4.Createing indexesProcess is executed on daily basis through SQL Agent job(every daymorning)using these tables we have created Reports.Whenever we executing the job we are getting this error.Description: "Time-out occurred while waiting for buffer latch type 3 for page (1:35837928), database ID 5.". End Error Error: 2012-08-09 09:35:36.99 Code: 0xC0209029 my databse size is 956334.13 mb.anybody knows the solution Pls Explain me. |
|
|
|
|
|
BUFFER LACTHC TYPE IN SQL SERVER 2008