DBInsight's Blog

Azure vs AWS: SQL Server Licensing Bang for Buck Comparison

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. What he was stating was that Azure maps a vCPU to a full CORE but AWS typically maps a vCPU to a Hyperthread for its EC2 […]

Continue Reading →

Posted in: AWS, Azure, Performance, SQL Licensing

Leave a Comment (0) →

Preventative SQL Server Monitoring

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. In this article’s case, the SQL Server Full Scans had significantly increased, […]

Continue Reading →

Posted in: Performance, SQL Server Monitoring, SQL Server Tools

Leave a Comment (0) →

Is your SQL Server VM sluggish? Then Check out the VMWare CPU Ready %

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. In most cases I was able […]

Continue Reading →

Posted in: Performance, SQL Server Monitoring, VMware

Leave a Comment (0) →

Wait Statistics and FileIO Delta Capture Utilities Updated

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. The DBA utilities that captures the deltas of Wait Statistics and Database File IO statistics have been updated recently to cater […]

Continue Reading →

Posted in: Free tool of the week, SQL Server Monitoring, SQL Server Tools

Leave a Comment (0) →

Migrating Database Mirroring to an Availability Group

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 […]

Continue Reading →

Posted in: Availability Group, High Availability

Leave a Comment (0) →

Preview of Premium Windows Azure SQL Database

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). Its quite evident from this release that some customers have suffered variation in […]

Continue Reading →

Posted in: Azure, Cloud

Leave a Comment (0) →

BI Corner – Enterprise BI Project using Microsoft Tools

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 project) that the latest MS BI toolset (eg. Power BI […]

Continue Reading →

Posted in: Business Intelligence

Leave a Comment (0) →
Page 4 of 7 «...23456...»