SqlDeep - SQL and BI technologies in depth

SQL Server Resource Governor is a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the amount of CPU, physical IO, and memory that incoming…

sys.dm_db_persisted_sku_features : dynamic management view to list edition-specific features that are enabled in the current database. If no features that may be restricted by a specific edition are used by the database, the view…

sys.dm_db_log_space_usage Returns space usage information for the transaction log. Column name Data type Description database_id smallint Database ID. total_log_size_in_bytes bigint The size of the log…

Installing Oracle 11g 32bit & 64bit clients would be a resolution of the famous 64bit OraOLEDB issue. Accessing an Oracle DB over a 64 bit system was a pain for many SQL Server DBAs. The purpose of this document is to explain how to…

sys.dm_db_log_info Returns Virtual log file (VLF)  information of the transaction log. Note all transaction log files are combined in the table output. Each row in the output represents a VLF in the transaction log and provides information…

Implementing a distributed transaction across multiple instances of databases is one of the most commonly used items which are less known by developers and DBAs. Here we intend to outline a method for executing distributed transactions…

Transaction Log Physical Architecture The transaction log in a database maps over one or more physical files. Conceptually, the log file is a string of log records. Physically, the sequence of log records is stored efficiently in the set…

Returns current lower-level I/O, locking, latching, and access method activity for each partition of a table or index in the database. Memory-optimized indexes do not appear in this DMV. sys.dm_db_index_operational_stats ( {…

Running out of disk space in TempDB can cause significant disruptions in the SQL Server production environment and can prevent applications that are running from completing operations. You can use the sys.dm_db_file_space_usage dynamic…