Category: sqlserver

Infrastructure as Code (IaC) in Azure, building an Highly Available SQL Server(FCI) with S2D+SOFS & Disaster Recovery(AG) in multiple Datacenters

*1337 Tech alert: Azure, IaaS, IaC, SQL Server, AlwaysOn AG/FCI, Networking, Clustering, VPN Vnet2Vnet, S2D, SOFS, Load Balancers, Health Probes… Helloooo! Besides SQL Server 🙂 On of my current professional personal pet projects is around Azure, I always liked Infrastructure/ networking related stuff; actually I was a SysAdmin back in 2004 managing stuff from DCs to Exchange,

Continue reading

Future: Leveraging Windows Server 2016 S2D with SQL Server 2016 to build hyper-converged clusters for the “Automated Datacenter” | Cloud/OnPremises

Hello! With the release of Windows Server 2016 and the “great/awesome/fabulous feature” storage spaces direct(S2D) that has the concept of leveraging local storage to build a “virtual-san”, with different storage type from SAS/SSD/NVMe to generate different storage tiers/caching that can be both applicable on the cloud and on premises, this is game changer for SQL,

Continue reading

Beware of SQL Server Online Index Rebuilds with an unexpected Update Stats causing locking and deadlock storms on complex distributed environments

Hello, Hope everything is running great! It is not that uncommon, that large/complex database environments might have an overlapp of maintenance commands being executed, being one of the classics the one bellow: Tipically DBA’s design their maintenance processes (that might include Integrity Checks/ Index Rebuilds/Reorgs/ Update Stats) to run on a daily basis under a

Continue reading

Exotic Troubleshooting in SQL Server Transactional Replication on *very* busy Subscribers + WindDbg + WPR & WPA

Hello again! 3 conditions need to be true for me to write something, 1st is having a little bit of spare time,the 2nd is to write about something that nobody hasn’t really blogged about (my search skillz might not be that 1337) and inspire at least one person to learn something new and stimulate curiosity. Moving forward to

Continue reading

World Wide Distributed SQL Server Service Broker Instances + C# Dev + Azure Service Bus-EventHub + Stream Analytics + PowerBI.com Scale-Out Challenge

Hello! As a frequent flyer I like to sleep on the airplane but since sleep is overrated and I’m in a long term relationship with Data Platforms 🙂 , I decided to write about one of the projects that I’m working on. Can’t disclosure all the details about it (NDA kicking in…), but I can

Continue reading

SQL Server Availability Impact on BigBox – Non yielding Resource Monitor after changing NUMA-NODE Processor Affinity causes instance to failover

Change NUMA-Node Processor Affinity is an online operation that can be done without causing downtime but I have experienced that it can lead to bring an instance offline if the resource monitor takes long time to free memory and keeps generating Mini-Dumps, at #51 it will bring the instance offline. Started to have Non yielding

Continue reading

Failed to bring your Mission Critical SQL Server Always On Failover Cluster Online after Patching!?

First of all, whenever issues arise from patching your SQL Server production environment, please keep calm 🙂 In a scenario, that you successfully patched SQL Server (Service Pack/ CU) but the SQL Server Resource Group can’t be brought online, I recommend to start your PowerShell console and generate your Cluster Log (simply by Get-ClusterLog), this will

Continue reading

Ninja Troubleshooting- User Interface freezing during SQL Server database restore

Hello world 🙂 To sum up, i was working with one of my customers regarding the UI (User Interface) freezing while restoring (Symantec NetBackup) a database into SQL Server 2012, leading to a unresponsive behavior from the server. Scenario (VMware guest – WS2012R2): Started with gathering performance counters to jump into the analysis and even though

Continue reading