Author

Mazidi Amin 11 posts 0 comments

Data is fascinating.

I make SQL Server faster and more reliable. Database administration isn’t about passing a certified exam, or about pointing and clicking your way through a crisis. Database administration is about applying the right solution at the right time, avoiding risk, and making robust choices that get you home each night in time for dinner with your family .

My areas of specialty are:

• SQL Server 2019-2008 performance tuning.

• Designing high availability and disaster recovery solutions.

• Securing SQL Server

• SSIS , SSAS

• Designing Data warehouse

Database Administration

How to Add logfile to suspect database when full log size?

Mazidi Amin May 19, 2020 0

Adds a log file to a file group when recovery cannot complete on a database due to insufficient log space (error 9002). After the file is added, sp_add_log_file_recover_suspect_db turns off the suspect setting and completes the recovery of…

Database Administration

How to Adds a data file to a filegroup when recovery cannot complete on a database

Mazidi Amin May 19, 2020 0

Adds a data file to a filegroup when recovery cannot complete on a database due to insufficient space on the file group (error 1105). After the file is added, this stored procedure turns off the suspect setting and completes the recovery of…

Database Administration

SQLSERVER 2017 CU3 and later: Query Store notice

Mazidi Amin Mar 21, 2020 0

Query Store notice If you use the Query Store feature, and you have previously installed Cumulative Update 2 (CU2) (14.0.3008.27), the following requirement applies to you: After you install Cumulative Update 3 (CU3) (14.0.3015.40) or a…

News

SQL Server 2019 now available on Ubuntu 18.04, supported on SLES 12 SP5

Mazidi Amin Mar 19, 2020 0

SQL Server 2019 package native to Ubuntu 18.04 ecosystem, fully supported for production use, starting with CU3.…

Database Administration

Resource Governor

Mazidi Amin Mar 19, 2020 0

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…

Database Administration

Features are restricted to specific editions of SQL Server

Mazidi Amin Mar 16, 2020 0

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…

Database Administration

Space usage information for the transaction log

Mazidi Amin Mar 16, 2020 0

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…

Performance and Maintenance

Determing the position of the last VLF in transaction log before shrinking the log file

Mazidi Amin Mar 16, 2020 0

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…

Installation and Configuration

Determing databases in a SQL Server instance with high number of VLFs

Mazidi Amin Mar 16, 2020 0

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…

Performance and Maintenance

Usage Scenarios for sys.dm_db_index_operational_stats

Mazidi Amin Mar 16, 2020 1

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 ( {…

Older Posts