Yes, that is my problem. I just need to tune this database for both queries and high volume inserts. many tables already have over 50 million records...
There is a third-party application that laods the data. It is loaded in batches every few minutes throughout the day.
The drive system is setup as follows: RAID 1 Drive C & Drive E RAID 5 Drive D So, Drives C and E share the smae spindles. Database files are on D,...
The application is using INSERT statements only.
I have an application that loads thousands of records an hour into a SQL Server database. The server is running very slow. The hard drives are being...
After restarting my production SQL Server, I am seeing this error in the SQL Agent error log: "[393] Waiting for SQL Server to recover databases......
Separate names with a comma.
