DBInsight’s Blogs

Azure vs AWS: SQL Server Licensing Bang for Buck Comparison
Posted by Rob Risetto on April 02, 2015

A Microsoft representative mentioned in conversation that the Azure IaaS cloud VM provides better bang for buck than Amazon Web Services (AWS) when using your own SQL Server licenses.

Continue Reading

Preventative SQL Server Monitoring
Posted by Rob Risetto on March 23, 2015

This article (here) from LogicMonitor provides some interesting performance counters to review to isolate potential SQL Server performance issues. The performance counter charts are from the LogicMonitor monitoring tool, however, the same counters can be captured using your favourite performance counter capture tool.

Continue Reading

Is your SQL Server VM sluggish? Then Check out the VMWare CPU Ready {2ec0bbd3bfdf207d2f0779c26660c3798ccadae611e41b6dbc787103c4a85cdd}
Posted by Rob Risetto on March 10, 2015

On numerous occasions I’ve had customers complain about intermittent SQL Server performance only to find that the root cause was not the workload generated by the SQL Server VM but that the VMware environment was oversubscribed and was not providing sufficient CPU resources to the SQL Server when required.

Continue Reading

Wait Statistics and FileIO Delta Capture Utilities Updated
Posted by Rob Risetto on February 26, 2015

Reviewing the deltas of Wait Statistics and Database File IO gives you a better indication of what is happening now on your SQL Server now and are not skewed by the historical accumulated values.

Continue Reading

2014 Predictions for SQL Server
Posted by Rob Risetto on February 05, 2015

At the beginning of each year I always like to check on what the head honchos/big hitters are predicting for the coming year, and then for gags I also come up with my own predictions. So here goes :

Continue Reading

Migrating Database Mirroring to an Availability Group
Posted by Rob Risetto on January 20, 2015

Recently I had to develop a migration plan to move a two server SQL Server 2008 R2 database mirroring environment to a two server SQL Server 2012 Availability Group (AG). The challenges were to minimise down time where possible, avoid transferring 40+ GB of database backups to the second server in the disaster recovery site and to perform the upgrade in line (i.e. no new equipment or VMs).

Continue Reading

Tuning a SQL Server 2000 System, Naaah!!!
Posted by Rob Risetto on January 03, 2015

Ok hands up who is still running SQL Server 2000 systems in production. I know you are out there.

Last week I had to determine why a set of DTS packages were running extremely slow. Perfmon indicated that the Disk IO latency was ranging from 50 ms to 1 to 2 seconds, that’s right seconds.

Continue Reading

BI Corner – Which SSAS Model Should I Choose?
Posted by Rob Risetto on December 20, 2014

If you are grappling with the decision on the correct SSAS model to use for your next BI project, then have a look at Melissa Coates article; Decision Matrix:  How to Choose Which Type of Model Meets Your Needs (Here).

Continue Reading

Preview of Premium Windows Azure SQL Database
Posted by Rob Risetto on December 01, 2014

Microsoft has announced a preview of a new Premium Windows Azure SQL Database offering. The Premium Windows Azure SQL Database product enables you to reserve capacity for your SQL Database which guarantees a fixed amount of dedicated resources (CPU, Memory and IO).

Continue Reading

BI Corner – Enterprise BI Project using Microsoft Tools
Posted by Rob Risetto on November 22, 2014

Jen Underwood from the SQL Server BI Blog, describes her journey of evaluating Microsoft BI tool offerings to support the requirements of an Enterprise BI Project.

In the article Jen outlines the enterprise dashboard requirements that had to be supported and highlights (for her BI

Continue Reading