by Barrie Shaw | Apr 17, 2013 | Blog, Databases
One of our Virtual-DBA clients recently contacted me for assistance in setting up connections using the DRDA protocol. They are moving from Java to .NET for their development work, and when they tried to connect via the .NET drivers, they received the...
by XTIVIA | Apr 5, 2013 | Blog, Databases
We have a client who needs to run monthly reports from their financial application. When we first started working for them, the monthly report took nearly a week to complete. We noticed a huge amount of logfile waits and did the classic tuning task of...
by XTIVIA | Mar 27, 2013 | Blog, Databases
Error: 9002, Severity: 17, State: 2 The transaction log for database ‘mydatabase’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases Very often clients come to us requesting assistance because...
by XTIVIA | Mar 27, 2013 | Blog, Databases
SQL Server 2005/2008: Find backup and restore status/progress Ever wondered how long it would take to complete a backup or restore that is running in the background. I, for one, do not want to keep looking at the job or TSQL that is taking the backup or doing the...
by XTIVIA | Feb 26, 2013 | Blog, Data Management, Databases
Often I am asked about the importance of a security audit, with the majority of these questions being asked by representatives of smaller organizations. The questions are centered around if there is a need to perform a security audit when the organization has taken...
by XTIVIA | Feb 22, 2013 | Blog, Databases
One of the important performance metrics we monitor for our Virtual-DBA and consulting customers is Page Life Expectancy (PLE). We look for low values as well as values that are trending lower over time. A drop in PLE is a prime indicator of memory pressure. PLE is...
by XTIVIA | Feb 20, 2013 | Blog, Data Management, Databases
We had a Virtual-DBA customer request that we install and configure a new Grid Control agent on a new server with existing databases. While there are several ways to do this, we wanted the customer to be able to perform this task by themselves in the future. The...
by XTIVIA | Feb 20, 2013 | Blog, Databases
At XTIVIA, we monitor and support multiple clients that use Lawson applications with a DB2 LUW (Linux, Unix and Windows) database back end. I wanted to share some of my experience and lessons learned over the years. Schema Layout: Out of the box, Lawson uses...
by XTIVIA | Feb 13, 2013 | Blog, Databases
Introduction A question we are often asked by both our Virtual-DBA and Consulting customers is: Why do I have to update statistics if auto-update statistics is turned on? The short answer is that your data changes, and even if you have auto-update statistics...
by XTIVIA | Feb 12, 2013 | Blog, Databases
Started: 1:03:12 PM Progress: 2012-02-08 13:03:15.24 Source: Data Flow Task Validating: 0% complete End Progress Error: 2012-02-08 13:03:16.15 Code: 0xC0047062 Source: Data Flow Task V91MOD APIMAG [1] Description: System.Data.Odbc.OdbcException: ERROR [IM002]...
