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

The Voice of the DBA

We Need DevOps for Performance

I read this nice piece on CosmosDB and setting performance levels. It covers how you set some level of performance for Request Units (RU) and CosmosDB handles the rest. Great, right? Set the level of performance you need and that gets handled. The question I have is how do you know what level of performance you need?

This is one of the issues with the Cloud services that I see. It doesn't matter if you use PaaS or IaaS, most of us really don't know what level of performance works. We tend to guess, and far too many of us don't use regular monitoring to decide if we are over or under powered. I find many DBAs and sysadmins would prefer to be over-provisioned and then let the server trundle along at a lower resource usage so that no one complains.

When we move to a cloud type service, we tend to be more cost conscious, which makes sense when we're paying by the minute. We want to minimum level of hardware we can get, but we don't want to cause unnecessary complaints, either from customers because the system is slow, or from the CFO because costs are high. Using your old method of over-provisioning hardware (or DTUs) usually causes complaints from the CFO.

The piece goes into some ways that you can start to evaluate your performance level for CosmosDB, and how to deal with throttling while you tune your RUs with a new application. This works great if you're in a (more) greenfield area of development. Not so great if you're lifting and shifting some application from another platform. Then we might need to ensure that we are responding quickly to issues, or better yet, have scripted responses that scale up or down.

The same thing should be done for our relational systems. The Ops part of DevOps needs to be using monitoring and instrumentation to measure performance, adding capacity as appropriate, which should be before users realize there's an issue. With today's virtual systems, adding CPU and RAM usually is fairly easy, and it's easy in the cloud as well.

Of course, all this monitoring isn't just to add capacity. Having a better sense of what's going on can help you pinpoint poor code. Getting someone to fix that code becomes a lot easier if you can show that better code would cost less for our systems. It can be amazing how much more developers care about their code when the CFO gets involved.

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.6MB) podcast or subscribe to the feed at iTunes and Libsyn.

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

The industry standard for comparing and deploying SQL Server database schemas

Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial

SQL Clone: Now supporting databases up to 64TB

Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free

Featured Contents

Database Cloning Tools in Lower Environments

John F. Tamburo from SQLServerCentral.com

With exciting products like SQL Clone making their debut, the DBA will need to think through the approach to implementing such powerful tools. Done properly, these tools will provide a massive benefit to both the DBA and developer. More »

What to Do When You Get a “Cache is Out of Date” Error Message

Additional Articles from Database Journal

Greg Larsen shows how to fix the “cache is out of date” error message when SQL Server Management Studio starts up. More »

What's your opinion on database DevOps?

Gartner predicts that the transition to agile and DevOps will be as disruptive to IT as lean was to manufacturing during the 1980s. What about you? Are you implementing a DevOps way of working? Do the same approaches apply to the database? Take part in this Redgate survey and they'll send you a copy of the research – and enter you in a prize draw to win a $250 Amazon voucher. More »

From the SQLServerCentral Blogs - Power BI Custom Visuals Class (Module 78 – Data Image by CloudScope)

Devin Knight from SQLServerCentral Blogs

In this module you will learn how to use the Data Image Power BI Custom Visual by CloudScope. The Data... More »

From the SQLServerCentral Blogs - What is Azure Databricks?

James Serra from SQLServerCentral Blogs

Azure Databricks (documentation and user guide) was announced at Microsoft Connect, and with this post I’ll try to explain its use... More »

Question of the Day

Today's Question (by Steve Jones):

I've got this table:

 CREATE TABLE Team ( PlayerID int , PlayerName VARCHAR(10) ) GO INSERT Team VALUES (1, 'Kendall'), (2, 'Maddie'), (3, 'Andrea')

What does this query return?

 SELECT COUNT(PlayerID) FROM dbo.Team HAVING COUNT(PlayerID) > 3

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: T-SQL.

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

SQL Server Query Store In Action

The Query Store changes the way you monitor performance on your databases and the way you tune the performance of those same databases. This book represents a deep dive into a large number of topics in and around the Query Store. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

When turning on automatic plan correction in SQL Server 2017, what options are available?

Answer: FORCE_LAST_GOOD_PLAN only

Explanation:

The Automatic Plan Correction feature in SQL Server 2017 only supports forcing the last good plan when a regression is detected. More tuning options are likely to come in the future.

Ref: Automatic Tuning - click here

» Discuss this question and answer on the forums

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 2017 : SQL Server 2017 - Administration

FT should never run as a domain account? - Hi: Is there any restriction like why the Full Text Search should need to run using "NT Service\MSSQLFDLauncher" and not preferred...

SQL Server 2017 : SQL Server 2017 - Development

Current Quarter - Hi Guys, I am using the below which does the following. Show the data for the current month unless today's date...

Shared stored procedure with very complicated input - So, the basics of what I want to accomplish is simple...I have a stored procedure that has some really complex...

SQL Server 2016 : SQL Server 2016 - Administration

Find a backup to rstore from takes 'Forever' - Hi All! As a part of me development tasks, I have to restore databases frequently from devices - local harddisk. Most times it's...

Can I rename the Primary Key of a replicated table ? - I have a very well established merge replication structure of 7 subscribers around a single publisher with many replicated tables. ...

Slow query - client or server issue - If seeing a client make a regular query that uses the same plan but completes in radically different times on...

SQL In-Place Upgrade Issue - I inherited a SQL 2014 machine and am trying to do an in-place upgrade and when it gets to the...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

pass table param - How do you pass a table like this? ;WITH TestTbl AS ( SELECT * FROM myTable ) CREATE FUNCTION Ex( TestTbl TableType READONLY) RETURNS VARCHAR(MAX) AS BEGIN DECLARE...

Does anyone use views in this way? - Hi, I know there are several cases where we as database developers need reference tables to help us with our querying...

SQL Server 2014 : Administration - SQL Server 2014

MSSQL Schema Export Only - Is there an easy way to do schema only exports in mssql

Trigger to notify when mssql job is disabled - I have a trigger that will let me know when a job is disable or enabled how do i add...

SQL Server 2014 : Development - SQL Server 2014

decimal places correction - Hi All, I want my numbers to be converted from a column which is of nvarchar(100) datatype to decimal(18,2). How can I...

Unusually Expensive Deletes - Hi all, I have a scenario on a few of our servers that I can't quite explain that I'm hoping someone...

Choosing the Birthday of a Customer by month? - CREATE TABLE birthdays( cust_id INTEGER NOT NULL PRIMARY KEY ,cust_fname NVARCHAR(50) NOT NULL ,cust_lname NVARCHAR(50) NOT NULL ,cust_dob DATETIME NOT NULL ); INSERT...

SQL Server 2012 : SQL Server 2012 - T-SQL

Help with code to Grouping the text in multiple lines - Hello everyone I am a newcomer to the world of TSQL and was wondering if someone can help me with the...

SQL Server 2008 : SQL Server 2008 - General

Stock take FiFo conundrum - Hello, I'd very much appreciate some advice/help with a stock take problem. I've had a look at https://ask.sqlservercentral.com/questions/1961/the-fifo-stock-inventory-sql-problem.html but my scenario differs somewhat....

Cloud Computing : SQL Azure - Administration

Scheduling jobs in Azure SQL database - Azure automation or Elastic jobs for EXPORT and IMPORT of a table? - Have recently created a database in Azure SQL database and I'm quiet new to it. Requirement - Have to export a table...

Data Warehousing : Strategies and Ideas

Good to have Multiple Data Warehouses? - Interesting debate came up on data warehousing. Is it good to have multiple data warehouses or just one? To add some...

Data Warehousing : Analysis Services

filtering using strtoset - Hi, i have the following MDX query that uses parameters from an SSRS report to produce a result set: WITH MEMBER...

Database Design : Design Ideas and Questions

Table Design - Dear Experts , Please share if there are any standard guidelines for designing the table objects , apart from Normalization , and Column...

This email has been sent to newsletter@newslettercollector.com. 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.