By Lori Brown | Expert , Miscellaneous , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah Statistics are pretty important to SQL Server. Statistics are small objects that hold information of the distribution of data in a table. The SQL optimizer uses this information to create efficient ways to get data from the table. So, if statistics are not taken care of SQL may have a […]
Continue readingBy Lori Brown | Expert , Log Shipping , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah I have a few clients who have set up SQL instances to hold copies of databases from either vendors or other companies with whom they are actively sharing data with. In these cases, since the source databases are on servers that are part of another company’s domain, the best way […]
Continue readingBy Jeffry Schwartz | Expert , Miscellaneous , Performance Tuning , SQL Development , SQL Server
The following testing and resulting data is a direct result of a recent issue that was discovered at one of our client sites. After setting up SQL monitoring that does use a SQL trace to capture long running queries, suddenly certain processes would lock up and be unable to complete. Initially we thought it was […]
Continue readingBy Jeffry Schwartz | Expert , SQL Development , SQL Server
— by Jeffry Schwartz Some functions in SQL are a little difficult to use and understand. I was recently using the LAG function to shed some light on a performance issue, so I thought I would show how I used it and the results it produced in a way that is easy to understand. At […]
Continue readingBy Jeffry Schwartz | Expert , Miscellaneous , SQL Development , SQL Server , Windows
The Problem How many times have you had to subdivide, group, rank, and organize data when you knew very little about the data itself except for the meanings of the columns? This dilemma is one that the members of the SQLRx team encounter frequently. When a customer requests help with a performance problem, we often […]
Continue readingBy Jeffry Schwartz | Expert , Performance Tuning , SQL Development , SQL Server
— By Jeffry Schwartz Microsoft introduced Extended Events, a.k.a. XEvents, in SQL Server 2008 to aid in the analysis of performance problems. Both the capabilities and syntax were changed significantly on SQL Server 2012, and new (and very important) features were added in SQL Server 2014. Therefore, the focus of this document will be on […]
Continue readingBy Ginger Daniel | Expert , SQL Administration , SQL Server
– -by Ginger Keys Occasionally mistakes happen, things get deleted, or hardware fails. Your end users may be complaining that the application is not working or pulling up any data… or you may open SQL Management Studio and see that the database is simply unavailable. What happened!? I have encountered a situation where an inexperienced […]
Continue readingBy Jeffry Schwartz | Expert , Performance Tuning , SQL Server , Windows
— By Jeffry Schwartz Whenever multiple data sources are used, actual or perceived discrepancies can arise. Sometimes this is due to the location of the data collector, e.g., Windows, SQL Server, or the disk array. Other times, it is due to the collection rate and whether the information is a simple recording of continuously incremented […]
Continue readingBy Lori Brown | Expert , Performance Tuning , SQL Administration , SQL Server
Sometimes it is good to have some queries in your toolkit that give you information on how things are running that includes the actual execution plan. While looking at Glenn Berry’s diagnostic query scripts (http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-september-2015/), which are very good btw, I found queries that will list stored procedure statistics but none had the execution plan […]
Continue reading