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 | Expert , Performance Tuning , Security , SQL Administration , SQL Server
If you have ever wondered what happens when you mistakenly enable Common Criteria compliance in SQL, well wonder no more!! We have a client who has no idea how or when Common Criteria was enabled on their production system. All they know is that performance has been slowly degrading. After collecting performance data, we found […]
Continue readingBy Ginger Daniel | Beginner , Security , SQL Administration , SQL Server
— by Ginger Keys Installing SQL following best practices is an important first step in securing your SQL server. The next step in securing your SQL server is to decide who can access the SQL instance, what databases and other objects they need access to, and what kind of permission to give them to those […]
Continue readingBy Ginger Daniel | Advice , Miscellaneous , SQL Administration , SQL Server , SQLRX , Windows
-by Ginger Keys We are going to re-promote this subject because it is still so relevant. All too often we run into people who are in a panic after looking at Task Manager to try to diagnose SQL stress. They seem to become very worried when looking at how much memory SQL uses not realizing […]
Continue readingBy Lori Brown | Intermediate , Miscellaneous , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah One of my clients has a rather large database with multiple filegroups and multiple database files in them. I happened to notice that a specific drive that is occupied by 2 specific files that are supposed to hold indexes is getting utilized at a much higher rate than any of […]
Continue readingBy Lori Brown | Expert , SQL Administration , SQL Maintenance , SQL Server
— by Lori Brown @SQLSupahStah Recently, I was checking on some of the servers that I manage and found that one had an 8GB msdb database. While that is not too bad it is kind of large so I figured that there must be something that needed to be cleaned up. I ran the Disk […]
Continue readingBy 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 reading