Home Page Icon
Home Page
Table of Contents for
Network
Close
Network
by Rod Colledge
SQL Server 2008: Administration in Action
Copyright
Foreword
Preface
Acknowledgments
About this book
About the cover illustration
About the author
Planning and installation
The SQL Server landscape
SQL Server 2008: evolution or revolution?
Editions and features
SQL Server tools
DBA responsibilities
Storage system sizing
Characterizing I/O workload
Determining the required number of disks and controllers
Selecting the appropriate RAID level
Selecting an appropriate storage system
SQL Server and SANs
Solid-state disks
Best practice considerations: storage system sizing
Physical server design
Disk configuration
CPU architecture
Memory configuration
Networking components
Server consolidation and virtualization
Best practice considerations: physical server design
Installing and upgrading SQL Server 2008
Preparing for installation
Installing SQL Server
Upgrading to SQL Server 2008
Developing a service pack upgrade strategy
Best practice considerations: installing and upgrading SQL Server
Failover clustering
Clustering overview
Clustering topologies and failover rules
Installing a clustered SQL Server instance
Best practice considerations: failover clustering
Configuration
Security
Authentication mode
Networking
Implementing least privilege
Auditing
Data encryption
SQL injection protection
Best practice considerations: security
Configuring SQL Server
Memory configuration
CPU configuration
Server configuration
Operating system configuration
Best practice considerations: configuring SQL Server
Policy-based management
Server management challenges
Policy-based management terms
Policies in action
Enterprise policy management
Advanced policy-based management
Best practice considerations: policy-based management
Data management
Database file configuration
Filegroups
BLOB storage with FileStream
Data compression
Best practice considerations: data management
Operations
Backup and recovery
Backup types
Recovery models and data loss exposure
Backup options
Online piecemeal restores
Database snapshots
Backup compression
Best practice considerations: backup and recovery
High availability with database mirroring
High-availability options
Transaction log shipping
Database mirroring overview
Mirroring modes
Failover options
Mirroring in action
Best practice considerations: high availability
DBCC validation
DBCC validation overview
Preventing and detecting corruption
Controlling CHECKDB impact
Removing corruption
Best practice considerations: DBCC validation
Index design and maintenance
An introduction to indexes
Index design
Index analysis
Index maintenance
Managing statistics
Best practice considerations: index design and maintenance
Monitoring and automation
Activity Monitor
SQL Server Profiler
Performance Monitor
Task automation and alerts
Best practice considerations: monitoring and automation
Data Collector and MDW
Component overview
Setup and configuration
Data collection
Custom collection sets
Reporting
Best practice considerations: Data Collector and MDW
Resource Governor
Resource Governor overview
Classifier function
Workload groups
Resource pools
Resource Governor in action
Monitoring resource usage
Best practice considerations: Resource Governor
Waits and queues:a performance-tuning methodology
SQLOS schedulers
Wait analysis
Common performance problems
Waits, queues, and DMV cross-reference
Best practice considerations: performance tuning
Top 25 DBA worst practices
Suggested DBA work plan
Daily tasks
Weekly tasks
Monthly tasks
Common Performance Monitor counters
CPU
Memory
Disk
Network
SQL Server
Top 10 Management Studio enhancements
Date/time data types in SQL Server 2008
DATE
TIME
DATETIME2
DATETIMEOFFSET
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Disk
Next
Next Chapter
SQL Server
C.4. Network
Network Interface:Bytes Received/Sec
Network Interface:Bytes Sent/Sec
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset