Using Extended Events to Find Statement Causing a Job to Run Long or Hang
SQLRx | The Daily Dose Blog
by Lori Brown
4M ago
On one of the servers that we monitor, it was reported that periodically a specific job would seem to hang and take forever to complete.  I was asked to set up something to help find exactly what statement in the job that was the root cause of the hang.  Since the issue only occurred intermittently, I needed to collect data every day until we could catch the job hang in action.  I decided to use extended events since the overhead of the collection would be minimal and I can limit the number and size of the files generated.  Since this is a very busy system, I also wanted to ..read more
Visit website
Monitoring Log Shipping Using T-SQL
SQLRx | The Daily Dose Blog
by Lori Brown
6M ago
Ah…. good ole Log Shipping.  Log Shipping has been around a long time and it looks like it will continue to be useful and therefor supported.  I know that when AlwaysOn came on the scene that many people assumed that Log Shipping’s days were numbered but that is not so.  I still have customers who opt for Log Shipping as a low-cost way to have some sort of DR solution.  So, since I still find Log Shipping being used, let’s talk about a T-SQL way to monitor it.  I tend to prefer to do much of my monitoring using T-SQL so that I don’t have to spend a lot of time opening ..read more
Visit website
Steps for Installing AlwaysOn Availability Groups – SQL 2019
SQLRx | The Daily Dose Blog
by Ginger Daniel
2y ago
With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made.  This article is an update to our previous article https://www.sqlrx.com/steps-for-installing-sql-server-alwayson-availability-groups/ , and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Add Windows Failover Cluster (WSFC) Install AlwaysOn Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure you have everything in your environment ready to go.  ..read more
Visit website
Find All Databases with Less Than 20 Percent Free Space and Grow Them
SQLRx | The Daily Dose Blog
by Lori Brown
2y ago
This is kind of a continuation of one of my previous posts.  (https://www.sqlrx.com/find-and-modify-file-growth-settings-for-all-databases/ ) Thousands of databases in a SQL instance can make a DBA’s life a bit challenging.  Automation suddenly becomes very important.  My new client had been shrinking their databases frequently, mistakenly thinking that doing so was a good thing.  I needed to check all of the data files for all databases to see how much free space they had and how much space needed to be added to each file to grow each database to have 20% free space availa ..read more
Visit website
Find and Modify File Growth Settings for All Databases
SQLRx | The Daily Dose Blog
by Lori Brown
2y ago
I have a client who is challenging me in a lot of ways.  They have over a thousand databases in one of their 2 SQL instances.  Over. A. Thousand.  Admittedly, the databases are not big but the sheer quantity of them is daunting to say the least.  To make it more fun, some of the databases have multiple files.   To some of you out there, that many databases might not be a big deal.  To me, it is a big deal.  That many databases can cause many admin tasks to take a very long time.  One such task is to review all databases to make sure that they are not gro ..read more
Visit website
We’re Baaaaaack!!!
SQLRx | The Daily Dose Blog
by Lori Brown
2y ago
If you have visited us within the past year, you may have noticed that we have been pretty quiet on our blog and may have wondered what happened.  Well…..we had some technical difficulties (our syntax highlighter plugin stopped working), then we got super busy, then came the holidays, then came COVID.  I know, Excuses…Excuses….Excuses.  Well, it really is the truth. Anyway….we are turning over a new leaf here at SQLRX and have finally gotten a new syntax highlighter and have managed to find time to put together a couple of posts.  If you don’t mind, take a look at the new ..read more
Visit website
Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2
SQLRx | The Daily Dose Blog
by Ginger Daniel
2y ago
In Part 1 of this series, we demonstrated how to copy a full SQL database table from a SQL Server database into an Azure Blob Storage account as a csv file.  My client needed data moved from their on premise SQL Server database to Azure, and then needed the daily incremental data changes uploaded as well.  This article will discuss how to upload the incremental data changes to Azure after the initial data load. Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 1 The general steps for uploading incremental changes in a table are: Enable Change Tracking ..read more
Visit website
Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 1
SQLRx | The Daily Dose Blog
by Ginger Daniel
2y ago
One of many options for Reporting and Power BI is to use Azure Blob Storage to access source data.  Most of the documentation available online demonstrates moving data from SQL Server to an Azure Database, however my client needed data to land in Azure Blob Storage as a csv file, and needed incremental changes to be uploaded daily as well.  This article will outline the steps needed to upload the full table, and then the subsequent data changes. The general steps for uploading initial data from tables are: Create an Azure Account Create an Azure Storage Account Determine which datab ..read more
Visit website
Backup and Restore Databases with CHECKSUM and VERIFYONLY
SQLRx | The Daily Dose Blog
by Lori Brown
2y ago
I found out that I have been missing something from our regular database backups that I had no idea that I should have been using all along.  I know about verifying your backup file and have incorporated into our standard maintenance routines one that will periodically test backups by restoring using VERIFYONLY.  However, I totally missed also having CHECKSUM specified when creating backup files.  Ugh!!  Not sure how that happened but I am totally onboard with it now.  Better late than never! **And now….DBA 101!!!!**  If you are not already, you should be performi ..read more
Visit website
Adding a Missing Index Killed Performance
SQLRx | The Daily Dose Blog
by Jeffry Schwartz
2y ago
Overview Recently, a customer requested that we tune a query that took 13 seconds to return 11 rows.  SQL Server 2017 suggested an index to improve performance, so we added it in a development environment.  The improvement made the query run 647 seconds, almost 50 TIMES longer than the original!  This naturally caused much consternation, so we decided to determine what and why it happened as well as how we could still achieve the original objective, i.e., make the query run faster.  This article discusses what caused the original performance problem in addition to the new o ..read more
Visit website

Follow SQLRx | The Daily Dose Blog on Feedspot

Continue with Google
OR