What is sql server 2008 backup compression?
Submitted by: AdministratorA compression backup is smaller than uncompressed backup. The backup speed significantly increases because it needs less disk space and I/O operations. The CPU usage is increased and the increased and the additional CPU that is consumed by the process of compression would impact the operations that are running concurrently.
The following processes can be isolated for obtaining a good picture
- Physical disk counters
- Device throughput bytes / second counter of SQL Server Backup Device object
- Backup/Restore throughput / second counter of SQL Server Databases object.
Submitted by: Administrator
The following processes can be isolated for obtaining a good picture
- Physical disk counters
- Device throughput bytes / second counter of SQL Server Backup Device object
- Backup/Restore throughput / second counter of SQL Server Databases object.
Submitted by: Administrator
Read Online SQL server 2008 Job Interview Questions And Answers
Top SQL server 2008 Questions
| ☺ | Explain Sparse Columns of sql server 2008? |
| ☺ | Do you know PowerShell included in SQL Server 2008? |
| ☺ | Explain how to store and query Spatial Data? |
| ☺ | What is Change Data Capture (CDC) feature in sql server 2008? |
| ☺ | Do you know Enhanced database mirroring in sql server 2008? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
