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.
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.
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.
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.
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 :
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).
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.
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).
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).
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