by XTIVIA | Jan 8, 2016 | Blog, Databases
This article is part 10 in a series on the top 10 most common mistakes that I have seen impact SQL Server Performance and Resiliency. This post is not all-inclusive. Most common mistake #10: Storage For the final post in the top 10 items that influence the performance...
by XTIVIA | Sep 17, 2015 | Blog, Data Management, Databases
Shortly after creating a database on your server you should be planning and scheduling your backup. Easy as it sounds it’s often approached incorrectly. Often the decision when to backup is based on when the server resource usage is low. Database Backup maintenance...
by Kathleen Long | Dec 18, 2014 | Blog, Business Intelligence, Data Management, Databases
If you are new to SSRS, or just new to the company and you have a developer promising you they deployed a report to the report server, but it had disappear from the display… Here is a hint of where you might find it. Here you have your report manager interface. The...
by Kathleen Long | Dec 15, 2014 | Blog, Data Management, Databases
A while back, I was tasked with using extended events to see what information could be captured to help a customer out with troubleshooting a performance issue. My first step was to see which SQL Server extended events were available on the server. With each version...
by Kathleen Long | Dec 8, 2014 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
While doing research for an upcoming add on to our standard Health Checks, I have been reviewing the different option to set in the configuration file for SQL Server Reporting Services. There are memory settings which should be addressed, especially if you are running...
by XTIVIA | Nov 25, 2014 | Blog, Data Management, Databases
Beginning in SQL Server 2005 Microsoft introduced a hidden database called the Resource Database. While it is often referred to as the resource database the actual name is mssqlsystemresource. The database contains all the system objects that are included with SQL...