DBInsight's Blog

Archive for Performance

Transactional Replication Performance and Virtual Log File Counts

Recently I came across a client that could not get their Transactional Replication data transfer to complete within a reasonable timeframe. Replication initialisation would work ok but from then on no data changes would make it through to the subscriber database. Initially I thought that either the Log Reader or Distribution agent had a connectivity […]

Continue Reading →

Posted in: Performance, Replication

Leave a Comment (0) →

Tuning Dynamic AX Master Resource Planning Process

Recently a client of mine was experiencing performance issues with the daily Master Resource Planning (MRP) process run, in particular, not only would it run for extended periods but it would also stop other users from performing their tasks. Looking under the covers I could see that a large blocking chain would develop just after […]

Continue Reading →

Posted in: Dynamic AX, Performance, SQL Server Monitoring

Leave a Comment (0) →

Host vs VM Guest Performance Counters, which is right?

I thought it would useful to highlight to readers that there can be differences in what a VM Guest performance counters show verses similar counters presented by the VMware performance charts. The following articles provide an insight into some of the discrepancies you may face. The first article Virtualization resource consumption counters lie to you […]

Continue Reading →

Posted in: Performance, SQL Server Monitoring, VMware

Leave a Comment (0) →

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) →

SQL in the AWS Cloud – SQL User Group PP Slides

Recently I presented the topic of SQL Server in the AWS Cloud to the Queensland SQL Server User Group. The presentation provided an overview of the potential SQL Server application use cases for the AWS Cloud, in particular, I demo-ed an AlwaysOn Availability Group failover from a AWS EC2 instance to a on-premise SQL Server […]

Continue Reading →

Posted in: AWS, Cloud, Performance, SQL Server 2014

Leave a Comment (0) →

Microsoft’s In Memory Strategy for SQL Server

It’s quite interesting that Microsoft’s SQL Server 2014 release has a number of In Memory performance optimisation features.  The clock speeds of CPUs have not significantly increased over the last few years  but memory has become relativity cheap and the 64 bit Windows platforms now provide substantial scope to run high memory footprints. Therefore it […]

Continue Reading →

Posted in: Business Intelligence, Performance, SQL Server 2014

Leave a Comment (0) →
Page 1 of 2 12