March 27, 2018 at 1:19 pm
jayoub - Sunday, March 11, 2018 2:30 PMThank you very much for the posts
We actually do not restore through the network we take full backup in PRD, copy the files to the NON-PRD via Powershell within an SQL Agent Job and then do the restore locally. I dont think any passwords are need but I will double check this since you brought it up. So far after the reboot, the job has run successfully two times and I will see on Monday if it still works.I will keep you posted
Again thank you very much for the help.
Back to the original issue your memory settings are likely incorrect. The max server memory needs to be set based upon the amount of RAM in the machine, and what else may be running on the server.
You are likely starving your operating system
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 28, 2018 at 6:36 am
Thank you very much for the posts
Looks like rebooting the server fixed the problem. Since I rebooted it the jobs have been running fine.
Jeff
March 28, 2018 at 9:12 am
jayoub - Wednesday, March 28, 2018 6:36 AMThank you very much for the posts
Looks like rebooting the server fixed the problem. Since I rebooted it the jobs have been running fine.
Re-booting is not a solution.
The issue will resurface, It appears that you need to fine-tune the settings of your server.
How much memory is in this server? A previous poster suggested configuring the max memory settings to leave 4 GB of RAM available to the OS. That number may not be enough.
A good read on the subject:
https://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/
Secondary items to look at are:
Is virus scanning enabled on the system? If so, are the proper items, be it folders, drives, or file extensions, properly excluded from the scan?
What is the disk configuration? How are these set up? Making a guess, the logical disks where the database files are located shares a PHYSICAL set of disks with other processes. They are competing with each other.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply