Author

Mazidi Amin 13 posts 0 comments

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

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 0

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

Database Administration

How to Monitor TempDB usage

Mazidi Amin Mar 15, 2020 0

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…

Newer Posts