How To Speed Up A Website Loading Time
The speed of your website is not only important to customers but also for you. So important that the primary search engine takes the website speed into… Read More
Let’s consider you are using SQL Server Analysis Services in MOLAP (Multi-Dimensional Online Analytical Processing) Storage Mode with Azure SQL Data Warehouse and everything has been… Read More
Starting with SQL Server vNext on Windows CTP 1.1, Analysis Services features a modern connectivity stack similar to the one that users already appreciate in Microsoft Excel and Power BI Des… Read More
I recently have a data import slowness issue reported taking days to process without finishing even in batch run in parallel. This issue could occur with any entity impo… Read More
If you have a Service Broker (SSB) application connecting to SQL Server using an AlwaysOn availability group listener, in the event of an unexpected failover, some messages may be lo… Read More
The SQL Server 2012 SSRS Report Manager Configuration Wizard failed when Changing Database on step “Applying Connection Rights”
Error Message: Cannot alter the role ‘RSExec… Read More
Hi!
I take advantage of a recent experience i had working with some customers implementing Websites under Azure Web Apps. This particular customerwas getting some 503 errors on the Slot, alt… Read More
Today we released PIX 1703.20.002 beta. New in this release:
NVIDIA GPU counters
File IO traces
Shader edit & continue
Pixel Cost visualizer
Improved Warnings UI. Where possi… Read More
Problem: SCCM Database Replication Service is not working
Solution: Service Broker had been disabled on MSDB, causing SCCM DRM to fail
I was recently called in to assist with a large System… Read More
I’ve been asked recently about performance profilers for various apps, and so I took another look at App Insights to see what’s new/different/interesting in that space.
Luckily… Read More
Hello all,
In this blog, I am covering the scenario of an approach to troubleshoot "SQL Server consuming High CPU" and few checklist points which will help in isolating/troubleshooting.
Belo… Read More
Yesterday, on a whim I launched SQL Profiler on my laptop. I had not launched the Profiler client for a long time, especially given its deprecated status. All the more, with the recent intro… Read More
Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Quick XE Trace’ capabilities. The feature is available in the latest SQL Server Management Stu… Read More
Abstract :
This is a memory leak oriented session for Internet explorer and Edge browsers. In this session, we will discuss on various examples to identify the memory leak patterns and how d… Read More
A week ago we posted an incomplete postmortem and are now following up with the competed version. If you want the full story of how we progressed through this incident, start by reading that… Read More
Hello all,
Recently, I had worked on an interesting Login failed error constantly getting reported in SQL Error log. In this blog, we are covering the steps taken to fix the issue.
Below er… Read More
Extended Events Step By Step
Introduction
I’ve read a few articles about using Extended Events (aka xEvents) to perform troubleshooting, and they do indeed provide a very powerful tool… Read More
Writer: Simon SuTechnical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah
Scheduling and Yielding Knowledge Recap
We all know that SQL server is a multi-threads and multi… Read More
Recently we encountered an issue using a Multidimensional Model where ROLAP and proactive caching were enabled on one of the partition. The notification was set to SQL Server table to track… Read More
Microsoft Detours from Microsoft Research is a powerful technology to intercept operating system function calls and detour the call to your own code. This enables: 1.  … Read More
Symptom
Creating a Peer 2 Peer publication from SQL scripts and you observe the Distribution Agents failing with "incorrect syntax near". These messages can be observed in SQL Serve… Read More
Hello all,
While working with SQL Server, one of the common issue application teams encounter is timeouts. In this article, we are covering approach to troubleshoot SQL Command/Query timeou… Read More
This article is worth a read if you have
A service written in .NET (and in particular .NET ASP.NET Core)
Its ability to service incoming load has topped out
But the machine's CPUs are not fu… Read More
Hello,
It is common to have this type of cases where our customer has millions of rows in a table and when they need to add a column and they reached the error transaction log full.
Dep… Read More
I was doing backups and clean-ups and ran across a couple of sample projects for XEvent and event_sequence processing I thought others might find helpful. – Enjoy!
The sample code is… Read More
Reviews 46The Private Eye Genre Progresses Reviews have not been indexed, but you may find most of these posts by searching this blog for keyword Review.In Reviews 45, we looked at the… Read More
Are you a working professional with a busy lifestyle? Are you stressed about not having time to go out for grocery shopping? We know how stressful it can get but gone are the days when we ha… Read More