Today we had a page file size issue, due to this the memory utilization was 16 GB, this stop all the integrations and giving out time out errors, the following actions where taken to resolve this.
1. Restart the sql server.
2. Check the database size.
3. Shrink the database mdb and log file size using the following scripts.
4. Check the max table size.
use manufacturing
exec sp_helpfile
dbcc shrinkfile (Manufacturing_Data)
No comments:
Post a Comment