Tag Archives for " SQLServer "

AlwaysOn – Create a Basic Availability Group

By Ginger Daniel | Always On , SQL 2016 , SQL 2017 , SQL Administration , SQL Server

AlwaysOn Basic Availability Groups (BAGs) are available with SQL Server 2016 and 2017 Standard edition.  The functionality is generally the same as database mirroring (which has been deprecated).  This feature replicates transactions to a database on a secondary server, and is useful for disaster recovery should something happen to the primary server. If you have […]

Continue reading

Rx for Demystifying Index Tuning Decisions – Part 4

By Jeffry Schwartz | Missing Indexes , Performance Tuning , Query Tuning , SQL Administration , SQL Server

Review In Parts 1 through 3 of this blog series the author discussed various aspects of SQL Server indices such as: Types of indices and their variations, e.g., clustered, nonclustered, filtered, and covering Physical versus logical index access methods, e.g., seeks, scans, key/RID lookups, singleton lookups, and range scans Why index tuning should begin with […]

Continue reading

Rx for Demystifying Index Tuning Decisions – Part 3

By Jeffry Schwartz | Installation , Missing Indexes , Performance Tuning , Query Tuning , SQL Development , SQL Server

Review In Parts 1 and 2 of this blog series the author discussed various aspects of SQL Server indices such as: Types of indices and their variations, e.g., clustered, nonclustered, filtered, and covering Physical versus logical index access methods, e.g., seeks, scans, key/RID lookups, singleton lookups, and range scans Why index tuning should begin with […]

Continue reading

Links for new DMV’s in SQL 2017

By SQLRx Admin | Miscellaneous , SQL 2017 , SQL Server

Since we at SQLRX have been super busy this week and still need to do something for a blog post, I thought that doing a link round up of new dynamic management views that are going to be available in SQL 2017 would be a quick and good idea. I am really interested in sys.dm_db_log_info […]

Continue reading

Use MSDB to Get Database Backup Size and Total Time For Each

By Lori Brown | Backup and Restore , Beginner , Helpful Scripts , SQL Administration , SQL Server

We recently started using a third party software to do our in-house SQL backups so that the backup files are stored in a redundant and safe place. To confirm that the software was indeed compressing backups as it stated it would, we wanted to see what each backup size actually was in SQL so that […]

Continue reading

Handling Multiple Missing Index Recommendations for the Same Table

By Jeffry Schwartz | Expert , Missing Indexes , Performance Tuning , Query Tuning , SQL Development , SQL Server

The Problem Many articles concerning SQL Server missing index recommendations demonstrate the mechanics for obtaining them and often highlight whether the suggested key columns are used in equality or inequality relationships. Most of these examples emphasize a single index that can be implemented to improve performance. However, real-life situations often involve multiple or many suggested […]

Continue reading

AlwaysOn 2016 – Encrypted Databases and Performance

By Ginger Daniel | Encryption , SQL Administration , SQL Server

It is common knowledge that encrypting a database causes degraded performance in a SQL server. In an AlwaysOn environment performance can be even more sluggish because there is the extra element of data replication latency. How much difference does it really make? Of course the answer is “it depends” on your environment and your workload. […]

Continue reading

AlwaysOn 2016 – Direct Seeding

By Ginger Daniel | SQL 2016 , SQL Administration , SQL Server

–By Ginger Keys SQL Server 2016 provides some awesome new enhancements and features, especially in Enterprise Edition.  One of the new features relating to AlwaysOn is Direct Seeding. Good stuff – No more time consuming backup and restore Direct Seeding allows you to initialize the databases to your secondary replica(s) without having to configure a […]

Continue reading

Common Criteria Compliance and LCK_M_SCH_M

By Lori Brown | Expert , Performance Tuning , Security , SQL Administration , SQL Server

If you have ever wondered what happens when you mistakenly enable Common Criteria compliance in SQL, well wonder no more!! We have a client who has no idea how or when Common Criteria was enabled on their production system. All they know is that performance has been slowly degrading. After collecting performance data, we found […]

Continue reading