By 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 | Intermediate , Miscellaneous , SQL Administration , SQL Server
–By Lori Brown @SQLSupahStah The dynamic management view sys.dm_server_registry has been around since SQL 2008 R2 SP1 so it is not new but it’s relatively new to me. Since I have a ton of SQL Servers to monitor, it is always good to have some way of easily knowing if there are any start up […]
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 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 Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server
–by Ginger Keys AlwaysOn Availability Groups made its debut in SQL Server 2012 as a new feature that enhanced the existing technologies of database mirroring and failover clustering to provide an option for high availability and disaster recovery. AlwaysOn gives you the ability to scale out several secondary Servers (replicas) for high availability or […]
Continue readingBy Lori Brown | Beginner , Miscellaneous , SQL Administration , SQL Development , SQL Server
— By Lori Brown @SQLSupahStah I was looking for a way to get info on the columns in indexes so that I could use the data to help enhance my index defrag routine. I found that my defrag logic did not figure out if an index has included columns that are LOBs and was failing […]
Continue readingBy SQLRx Admin | Advice , Installation , Miscellaneous , SQL Server , Upgrade
In case you live under a rock or were at the dentist, Microsoft announced that SQL Server 2016 has been made generally available today June 1, 2016. See: https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/ Pricing is as follows: A handy feature comparison of previous versions of SQL can be located here: https://www.microsoft.com/en-us/server-cloud/products/sql-server/comparison.aspx SQL 2016 feature comparison between editions can be […]
Continue readingBy SQLRx Admin | Advice , Miscellaneous , Offer , SQL Server , SQLRX
For those of you who visit our humble blog from time to time and have never actually checked out our website (www.sqlrx.com) to get acquainted with what we do, please allow me to check that box for you. SQLRX is part of a Dallas, Texas based consulting company called Integrated Services Inc (ISI). The SQLRX […]
Continue reading