SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

SQL Server I/O affinity and Snapshot backups - speed up the maintenance activity on your database

published 754 days, 20 hours, 44 minutes ago posted by

sa 761 days, 22 hours, 8 minutes ago

SQL Server I/O affinity and Snapshot backups - speed up the maintenance activity on your database

Back in SQL Server 2000 version days (I think) SP1 onwards the affinity mask configuration option has been introduced, which refers to IO_affinity_mask_switch using SP_CONFIGURE statement. I/O affinity dedicates special, hidden schedulers to performing core buffer pool I/O and log writer activities. Just a brief background about the affinity mask (from Technet) as follows: Specify which CPUs in a multiprocessor computer are eligible to process SQL Server disk I/O operations. The IO_affinity_mask...(read more)

category: News | clicked: 1 | | source: sqlserver-qa.net | show counter code

tags: Backup, Best Practices, configuration, Monitoring, Performance, SAN, snapshot, SQL Server, vdi

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL Server I/O affinity and Snapshot backups - speed up the maintenance activity on your database

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up