Tag Archives for " SQLServer "

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

SQL 2016 Automatic Seeding of Availability Groups

By Lori Brown | Expert , SQL 2016 , SQL Administration , SQL Server , Trace Flags

I came across something today that I did not know existed in AG’s, Automatic Seeding. This allows SQL to automatically create the secondary replicas for all databases in an AG. Pretty cool!! So if you set things up correctly when you set up your AG’s, you don’t have to worry about backing up databases and […]

Continue reading

SQL Toolkit – Get List of Database Options and Features

By Lori Brown | Helpful Scripts , SQL Administration , SQL Server , SQL Toolkit

–By Lori Brown I am going to start up a thread with some queries that I consider to be important to DBA’s. As a consultant, many times we have to start managing SQL instances without any knowledge of why it has been configured in various ways. We usually try to work with our clients to […]

Continue reading