By Lori Brown | Performance Tuning , SQL Administration , SQL Server
I occasionally come across some pretty good sized databases that are set up with a single data file. We recently have been working with a client to break up their single data file into multiple data files so that we can spread them over several different LUNs and so that they can take advantage of […]
Continue readingBy Lori Brown | Dependencies , Object Information , SQL Administration , SQL Development , SQL Server
In my last post I covered finding objects that reference another object using the dmf, sys.dm_sql_referencing_entities. (https://www.sqlrx.com/finding_things_sql_that_reference_a_table/ ) Now let’s reverse that and find what objects are referenced in stored procedures or views. When updates are needed to business logic often that happens in these objects. If the stored procedures or views are large with […]
Continue readingBy Lori Brown | Dependencies , Object Information , SQL Administration , SQL Development , SQL Server
Have you ever been asked to make changes to a table that is used by other things/processes? One of the challenges is to figure out what will be impacted by the change. This way you can know what to check and test so that the change is rolled out with success. One good place to […]
Continue readingBy Lori Brown | Helpful Scripts , SQL Administration , SQL Server , SQL Toolkit
It is pretty common that I frequently am asked to take over a server with SQL on it sight unseen. Many times shops many not be fully aware if additional instances are or have been installed on their server. Since I am working on a set of scripts that we can use for discovery on […]
Continue readingBy Lori Brown | Indexes , SQL Administration , SQL Maintenance , SQL Server
I was doing some performance analysis at a client where we captured a traditional SQL trace. Our client has SQL 2016 Enterprise that is fully patched up and uses Ola Hallengren’s IndexOptimize (https://ola.hallengren.com/) stored proc to do nightly index maintenance. While the index maintenance ran, we caught over a hundred thousand Error 1105, Severity 17, […]
Continue readingBy Lori Brown | SQL Administration , SQL Server
Tempdb is a system database used in SQL Server to hold 1) temporary user objects like temp tables and stored procedures, 2) internal objects like work tables used for sorting, and 3) row versions created from data modification transactions. When configuring a new SQL Server, the tempdb should be set to a size that will […]
Continue readingBy Lori Brown | Backup and Restore , Helpful Scripts , SQL Administration , SQL Server
Recently I had a client who contacted me because all of the sudden the backup for a couple of databases started to fail. While those backups had been running successfully in the past they suddenly started failing with this message: With a little more digging he found more info. Here is more verbiage from the […]
Continue readingBy Lori Brown | Helpful Scripts , SQL Administration , SQL Server , SQL Toolkit
We recently were troubleshooting an issue where one client reported that the SQL instance was suddenly very slow. One of the things we do is check to see what queries are currently running in SQL by using the following query: — Finds info on queries that are running NOW SELECT GETDATE() AS CurrentTime, SUBSTRING(text, CASE […]
Continue readingBy Ginger Daniel | Backup and Restore , Database Mail , SQL Administration , SQL Server
According to best practices for a SQL environment, you should never place your test or development databases on a production server. However sometimes best practices are ignored, sometimes the DBA’s advice is disregarded (ahem…), or sometimes an organization simply does not have the financial resources to spin up separate servers for testing or development. Whatever […]
Continue reading