Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backup procedure and CPU/memory consumption
Message
From
23/01/2017 00:29:32
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Backups
Title:
Backup procedure and CPU/memory consumption
Environment versions
SQL Server:
SQL Server 2014
OS:
Windows 8.1
Network:
Windows Server 2012
Miscellaneous
Thread ID:
01646946
Message ID:
01646946
Views:
40
On a specific environment, a backup is performed using SQL Server regular commands. So, this is from the built in functionality as it is not using an external tool such as Red Gate or Barracuda.

As opposed to before, when that procedure was executed on a previous environment, in the new environment, on pretty much every time it is running, in the first few minutes, it seems that it takes all CPU and/or memory resources and pretty much nothing can be done against the SQL Server during that time, nor the server as it is so tied down that RDP is completely cut off. Before, when doing such, I recall we were allowed to continue regular functionalities, at about 80% of capacity I would say. But, now, we are talking about a total lock for a random amount of time ranging from 30 to 120 seconds. There is much more memory than before, more CPU, and everything up to date. I never had to restrict resources down to a certain percentage, if that would be possible, up until now. Could this be something required on Windows Server 2012 with SQL Server 2014?

Otherwise, if this is known to cause problems or not performing as pretty much transparent as other tools, would it be recommended to use specialized tools for doing such procedure?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform