Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Redgate SQL Compare
The Voice of the DBA
 

Waits and Queues

How many of you have read this article: SQL Server Performance Tuning Using Waits and Queues? (PDF) If you haven't, you might look at a review of the paper from Jeremiah Peschka. There is good advice about which parts to read and which to ignore a decade later. There's an updated version from Paul Randal and SQLSkills as well.

This leads me to where you might expect this week, with a question for you. Do you use waits and queues to troubleshoot? (Survey)

Not every performance problem needs you to dig deeply into the way that the database engine processes your query, but there are no shortage of times when understanding waits and queues can help you determine how to tune your system. This is a well known method of trying to determine where to focus your efforts, so I wonder how many of you have tried this.

If you have, let us know what's worked or what hasn't. If you've never tried this, then drop a quick note as well if you have a reason you haven't used waits and queues.

Performance tuning is a skill everyone needs, and most everyone can work on. This is often one of the most popular topics for talks and classes, and any help you can get will grow your career. Both in your own self confidence as well as impressive to interviewers when you have an answer or a methodology to give when solving any problems you're given.

Steve Jones - SSC Editor

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

Redgate SQL Change Automation
 
  Featured Contents

Importing Files in Parallel with SSIS

Paulo de Jesus from SQLServerCentral.com

Run multiple instances of your package in parallel so that each instance processes a portion of the total number of files

Scaling SQL Monitor with your growing estate

Additional Articles from Redgate

Tony Davis describes the features and capabilities of SQL Monitor that allow it to scale smoothly to monitor a growing estate of servers and databases, while still providing a single, simple dashboard that gives the team all of the essential SQL Server metrics and alerts, establishes baselines, and detects trends in behavior.

Improve Data Quality for SQL Server Reporting

Additional Articles from MSSQLTips.com

Poor data quality for any reason is very expensive in terms of man hours and decision making to all organizations. There are a number of ways to address the issue with both SQL Server Reporting Services and Power BI.

From the SQL Server Central Blogs - Production Kubernetes

Steve Jones - SSC Editor from The Voice of the DBA

Still learning more about Kubernetes. I’ve been working through the 50 days of Kubernetes (K8s). Let’s keep exploring The API is the security boundary Everything happens with the Kubernetes...

From the SQL Server Central Blogs - Podcasts on Modern Data Warehouse

James Serra from James Serra's Blog

I did a couple of recent podcasts that I wanted to mention: The first one was with Kirby Repko from the YouTube channel SQLTalk: Modern Data Warehouse Design with...

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Synonyms for Tables

Which of these can I not create a synonym for in SQL Server 2017?

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

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Database Auditing

I want to audit my SQL Server 2017 instance with the SQL Server Audit feature. I want to audit backup and restore activity for 3 databases. What are the minimum Server Audits and Database Audit Specifications that must I create?

Answer: 1 Server Audit and 3 Database Audit Specifications

Explanation: One Server Audit is needed to contain the audit specifications. Each database needs its own Database Audit Specification. Ref:

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 - Administration
disable CEIP - Hi everybody, I just want to know, how to disable the CEIP service. I know this two links: SQL Server 2016 – SQL Server Telemetry CEIP Services Disable or Turn-off SQL Server Telemetry Service But on this microsoft page, they tell me, that the CEIP service had to run, otherwise my support maybe lost: "Removing […]
SQL Server 2017 - Development
Convert Seconds to Minutes - Guys, is there a way to add a new column to show HH-MM-SS ( as per below example).  In excel for example i would simply divide the seconds by 86400 and change the format in the column to hh-ss-mm. IF OBJECT_ID('tempdb..#Log') IS NOT NULL DROP TABLE #Log SELECT * INTO #Log FROM (VALUES ( '10', […]
CAST FOR XML - Illegal Name Character - I am trying to write a query that generates an html report to be emailed and one of the columns is a hyperlink to our report server that we can click on from the email and it will open the report in report browser.  It needs to pass the row value as a parameter to […]
SQL Server 2016 - Administration
Replication Error - TCP Provider: The semaphore timeout period has expired.  - Experts, We are facing an issue with one of the replication subscriber. There were already two subscribers and replication is working fine since long time for both. Recently added one more subscriber and while configuring replication we are getting the below error. TCP Provider: The semaphore timeout period has expired. This error occurs with ONLY […]
Revert a database to a DB Snapshot - We are a product based company and using SQL Server as backend. Whenever there is a new version of OUR product released, we will upgrade the product for all our SaaS customers  and upgrading the product across all the SaaS Customers have been automated. As a pre-upgrade process, we will take DB Snapshot and if […]
SQL Server 2016 - Development and T-SQL
Get the inactive records in sqlserver - HI Team, please help to get the expected data. my Data like below: create table #comapny ( companyid int, childname varchar(100), activeid int) insert into #comapny select 1,'aaa',0 union ALL select 1,'bbb',0 union ALL select 1,'ccc',1 UNion ALL select 2,'ddd',0 union ALL select 2,'eee',0 union ALL select 1,'fff',0 select *from #comapny Existing Data: companyid childname […]
Administration - SQL Server 2014
Data Migration - Hi , Our new project demands migration of data from Oracle database to multiple SQL Server databases. We are planning to go with SSIS package to achieve this. Is there any better way to achieve this?
DBCC8 File - Hi, There is a X._mdf_mssql_dbcc8 file on one of the drives occupying 350GB. I hope it got created due to DBCC CheckDB on database and whether can it be deleted and what information are recorded in it. Will it affect the database if it's been deleted?  Any idea how it got created?  
Development - SQL Server 2014
Primary Key and Clustered Index - A topic I always get confused with is primary key vs. clustered index. I have an understanding of what each is and/or is not but I struggle with the application of the two. Suppose I have a table with an account number field in which all account numbers are unique. Is it worth having an […]
odd error message in function in a proc - I have a cursor which has calls a function (sorry for  design this is a 3rd party db).  Odd part is there are 10 rows in the cursor select, only every other row gets updated, next row gets error below.  This happens no matter what the sort order is, one row works, next row errors, […]
SQL Server 2008 - General
Data Migration Assistant errors - dacpac and openquery failures - Hi all, I am attempting to use DMA to assess an upgrade from 2008 R2 to Asure SQL on VM. Our database has linked servers and many views that use openquery. I'm receiving a lot of errors running DMA. First is 'Failed to extract dacpac at location 'C''. Second is a load of errors like: […]
Reporting Services
Trimming then adding text - Hello I have an output in my queries that gives me: xxxxxxx xxxxxxxxx : 123456 (xx) - xxxxxxx... or xxxxxxx xxxxxxxxx : 123456789 (xx) - xxxxxxx... basically text before either a 6 or 9 digit number then text after I've created a column in a table in SSRS that just shows the number, and I used this […]
Integration Services
Scalable SSIS Package - Single SSIS package across 50 different projects - Hi All, I have a successfully running SSIS package which has been created for a single project. It works over a pipe-delimited file and pulls the data from the source, and loads it directly into the destination table. For each projects, I am using the same job to execute based on a job execution table. […]
How to make in memory SQL transformations within a data flow task - Hi all, first of all, I am new to Integration Services. I googled everything so far, but I do not find any answers on my question. So I hope anybody of you can help me out :-). Currently, I am migrating an T-SQL ETL process to SSIS to see the benefits in parallel executions and […]
T-SQL
CASE statement headache - Hello I have an output in my queries that gives me: xxxxxxx xxxxxxxxx : 123456 (xx) - xxxxxxx... or xxxxxxx xxxxxxxxx : 12345678 (xx) - xxxxxxx... or xxxxxxx xxxxxxxxx : TEST12345678 (xx) - xxxxxxx... basically text before either a 6 or 8 digit number then text after.   Ideally I'd like to be able to CASE this column so […]
 

 

RSS FeedTwitter

This email has been sent to {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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -