SQL Server and VMware Resource Pools
Resource pools are used to hierarchically partition available CPU and memory resources, and are available for use at the VMware host cluster layer. To better prioritize certain VMs over...
2020-04-06
69 reads
Resource pools are used to hierarchically partition available CPU and memory resources, and are available for use at the VMware host cluster layer. To better prioritize certain VMs over...
2020-04-06
69 reads
Dynamic Resource Scheduling (DRS) should be enabled for all VMware host clusters, especially those who run SQL Server. It provides for resource consumption load balancing functionality into a host...
2020-03-25 (first published: 2020-03-16)
356 reads
I’ve talked for months now about the ability to run SQL Server on the Linux platform. For those of you interested in exploring the benefits of this platform, you’re...
2020-03-19
124 reads
By default, the vSphere vCenter deployment contains a virtual appliance where the VMware management and orchestration platform, vCenter, resides and runs from. The default performance metric statistics collection interval...
2020-03-16 (first published: 2020-03-09)
277 reads
I’m proud to announce that I’ve been awarded the VMware vExpert community award for the calendar year 2020. I’m absolutely thrilled to be awarded this title for the eighth...
2020-03-04
8 reads
This Wednesday, February 26th, I will be presenting a new session entitled “All Things SQL in the Microsoft Cloud” for the Omaha Azure Users Group, starting at 6pm Central...
2020-02-24
8 reads
For years, I’ve done consulting around helping organizations tune their database platforms, both from within the database and underneath, to help boost performance and availability. Some database design or...
2020-02-06 (first published: 2020-02-03)
776 reads
A wonderful reader of my blog sent me a note (thanks Jess!) about a single line notation in the latest SQL Server release notes. The notes is as follows....
2020-01-15 (first published: 2020-01-06)
859 reads
GigaOm, an independent research firm that I highly respect, released a study today comparing performance and price between a SQL Server VM on Microsoft’s Azure platform and a SQL...
2019-12-19 (first published: 2019-12-04)
739 reads
As leader of the PASS High Availability and Disaster Recovery virtual chapter, I invite you to bring your questions for a mega open Q&A session on Tuesday, December 10th,...
2019-12-04
50 reads
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
BCA KCP Blok M Telpon/WA:08137887595.Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota...
Blok G 7 C No, Jl. Danau Sunter Utara 1 dan 2, Sunter Agung,...
BCA KCP Cilandak KKO I Telpon/WA:08137887595.Jl. Raya Cilandak KKO No.9, Ragunan, Ps. Minggu, Kota...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers