SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

Actionable Metrics

One of the tenets of Devops is that we learn from the feedback we get from our system. This means that we actually need to include some instrumentation in our application as well as a way to gather, store and analyze this data. There are various frameworks to do this in application code, but we also need to include the database in here. This might mean we need to add some logging or messaging in our T-SQL code, whether to some table or file, integrating with extended events, or something else. I wish to I had a best practice for you here, but there are multiple ways to do this and the best way for different environments can vary. At the least, you need some sort of resource monitoring if nothing else.

We don't want to just collect all the data we can, nor do we just pick some random items. We want to think about how our system works and then choose useful data. The key to useful metrics is that they are actionable. We can change behvaior or alter the system based on the information. In other words, we can take some action, positive or negative, based on what the metric tells us about our system. Without this, it might just be useless data that we're collecting and storing, for no particular reason.

Of course, we might not know how useful some metrics are for awhile, so we may need to collect data that we can't use right now. If we find that's the case later, perhaps we cease gathering useless data after we can't find value over some period of time, maybe months. However, we do need to perform some analysis and investigation to determine if there is a way to extract information from our metrics.

Ultimately I tend to err on the side of gathering a bit more data than I need, even if its value is suspect. I'd rather have more data that I need to delete than find myself wanting later and wishing I'd just collected a few more metrics. The key thing is to actually take some time to look at your data and use it to make decisions. Once you find the data helping to drive the behavior of the organization, I think you'll start to find ways to gather more and more useful information in other systems.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 3.1MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

ADVERTISEMENT
SQL Clone

NEW product launch: SQL Clone - live stream this March!

Data Platform MVPs Grant Fritchey and Steve Jones show how to create database copies in seconds using MBs of disk space with Redgate’s NEW database provisioning tool SQL Clone! Tune in to this live stream session on March 29th 2017. Register now.

Featured Contents

 

Detective Stories - Tracking Down the Database's Dependents Part 2

Brandie Tarvin from SQLServerCentral.com

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article. More »


 

SSIS Catalog Compare v2.0 Launch Event

Press Release from SQLServerCentral.com

Join the SSIS Catalog Compare v2.0 Launch Event on Tue, Mar 7 at 13:00 EST. More »


 

Query Store and In-Memory OLTP

Additional Articles from SimpleTalk

Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the natively-compiled stored procedures and memory optimised tables that come with In-Memory OLTP? Do you get the full range of runtime statistics? This is an intriguing question that Enrico explores and answers. More »


 

From the SQLServerCentral Blogs - SQL VNext sp_configure on Windows and Linux with dbatools

Rob Sewell from SQLServerCentral Blogs

This weekend I set up some SQL vNext virtual machines, two on Windows and one on Linux so that I... More »


 

From the SQLServerCentral Blogs - Power BI Custom Visuals Class (Module 40 – Long Text Viewer)

Devin Knight from SQLServerCentral Blogs

In this module you will learn how to use the Long Text Viewer Power BI Custom Visual.  The Long Text... More »

Question of the Day

Today's Question (by Steve Jones):

I need to purchase a new SQL Server 2016 Standard Edition server, but I don't want to waste hardware. Which of these is a poor purchasing decision for a dedicated SQL Server machine?

Think you know the answer? Click here, and find out if you are right.


We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: SQL Server 2016.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

Yesterday's Question of the Day

Yesterday's Question (by Henrico Bekker):

Which system database will by default be encrypted when enabling TDE encryption on any user database?

Answer: tempdb

Explanation:

The tempdb system database will be encrypted if any other database on the instance of SQL Server is encrypted by using TDE. 

Ref: Transparent Data Encryption - click here


» Discuss this question and answer on the forums

Featured Script

SQL Login Password Audit

Jim Youmans from SQLServerCentral.com

This stored procedure will find all the SQL Logins on a server and tell you the age of the logins password and it will also check for blank passwords and passwords that are the same as the login name.  If you create a common password table, it will also check the logins passwords against those in your table.  The common password table format is:

CREATE TABLE [dbo].[CommonPwds](
[pwd] [varchar](25) NULL
) ON [PRIMARY]

More »

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2016 : SQL Server 2016 - Administration

Please explain difference between these terms - Server authentication” vs “Windows authentication Server Roles vs Database Roles Logins vs Users


SQL Server 2014 : Administration - SQL Server 2014

checkdb "Multiple IAM pages for object" - Hi all, my last checkdb return this error for 6 tables: this is an example: Table error: Multiple IAM pages for object...

All Columns as Included - Hi Experts, Have a select query which is selecting 40 columns .Created index with key columns in where clause and added...

Create sql login for reporting activity - Hello, I need help to accomplish a 'simple' task. Our customer need to connect to our sql server (one server for all...

Very large Indexes (~3TB) and need to rebuild fast - Hi, Hi, We have a 40 TB DB, and have some big tables and few indexes which are too big now to...


SQL Server 2014 : Development - SQL Server 2014

De-Concatenate multi-select picklist and transform into target multi-select picklist values - Hi,  I have a requirement where I have to tranform an existing multi-select picklist column. The source data exists in the folllowing...

How to overcome the identity column "jump 1000" issue - Hey, Since SQL2012 MS changed something with the identity column; after a restart the value jumps with 1000 (for INT identity...


SQL Server 2012 : SQL 2012 - General

SQL Syntax help on getting a table listing.... - OK, so here is what I need I need a listing of tables from any database. ( Lets assume there is only...

The Accidental DBA - Wait Stats - Hello All, Am after a little bit of advice. In my ever expanding career as a DBA with my current company, a...

Use date and time in sql statement for join, but not required in the output - Afternoon, I'm using the date / time from a view to join on the date / time from another part of the view,...

Trying to figure out why a trigger fired - we have 2 triggers on one of our SQL servers. One checks for one of 4 logins and 4 apps...


SQL Server 2012 : SQL Server 2012 - T-SQL

How to make one innerjoin to bring all value of all the substrings within a string separated by a comma - Hi,  I have two tables, answers and lookup, In my answer table I have a field named: value, it my contain...

Number of integers where digits are not repeating. - --------- This is for fun only                                      --------- --------- This is for fun only (and for my education) --------- --------- This is for fun only                                    

Set query order by comparison result of two fields - I have a dataset like below: CREATE TABLE .(      IDENTITY(1,1) NOT NULL,      (50) NULL,      (20) NULL,      NULL ) ON...

TRIGGERS ON VIEWS - I have created a view which as you know pulls information from base tables.  Now this view stores live information pertaining...


SQL Server 2008 : SQL Server 2008 - General

Need urgent help for creating index on subscriber replication server -


SQL Server 2008 : T-SQL (SS2K8)

Primary key violation on INSERT, even though TABLOCKX is held - Hi I have an issue where a stored procedure runs the following code and a PK violation is reported (although I...

Cursor Insert into table with IDENTITY crisis - I have been coming at this problem from several different angles, off and on, for a few weeks now.  This...


Data Warehousing : Integration Services

Source Code Control organization - I am admittedly a newbie to Source Code Control (TFS in our case). We started the process by storing all...


SQL Server 2005 : Administering

Linked Server - I am having error on my linked server. from x to y. OLE DB provider "SQLNCLI" for linked server "x" returned...

This email has been sent to {user_email}. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com