Microsoft has introduced an interesting and exciting new feature in SQL Server 2008; it is named the Resource Governor. It allows the user to limit the CPU and memory usage by a specific application or user. It would help in preventing any particular user / application to eat up all the resources of the SQL…
Categories
- Backup and Restore
- Concurrency Control
- Connectivity Issues
- CTE
- Database Mail
- Database Maintenance
- Database Mirrroring
- Dealocks
- Disaster Recovery
- Disk I/O
- Error Log
- Extended Events
- FTP
- High Availability
- In-Memory OLTP
- Indexes
- Log Shipping
- MDW
- Memory Configurations
- New Features
- Performance issues
- Performance Tuning
- Plan Cache
- Policy Based Management
- PRINCE2
- Project Management
- Replication
- Reporting Services
- Resource Database
- Resource Governor
- Revolution Analytics
- rto rpo
- SQL Server
- SQL Server Admin
- SQL Server Administration
- SQL Server Alerts and Notifications
- SQL Server Architecture
- SQL Server Errors
- SQL Server Extended Events
- SQL Server Indexes
- SQL Server Locks
- SQL Server on Linux
- SQL Server Security
- SSRS
- Storage Internals
- Stored Procedures
- System Databases
- Table Variable
- TDE
- Temporary Database
- Temporary Tables
- Temporary Variables
- Transaction Log
- Transaction Log Shipping
- Transactional Replication
- TSQL
- Uncategorized
- Wait Stats
My Cool Posts…
- SQL Server Database mirroring modes and patner timeout
- SQL Server Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405
- SQL Server error 18456 cannot connect – SQL Server 2017 LOGIN FAILED ERROR 18456
- How to check Deadlocks in SQL Server
- SQL Server- Unable to connect to SQL Express Error: 26-Error Locating Server/Instance Specified
- SQL Server- a network-related or instance-specific error occurred while establishing a connection to sql server
- SQL Server error 40 could not open a connection to sql server 2016
- What’s new in SQL Server 2017 vNext
- SQL Server- Identify location of the SQL Server Error Log file
- Microsoft SQL Server Error: SQL SERVER – Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ‘)’ or msg 102 level 15 state 1 line 3 incorrect syntax near ‘ ‘