OCEANSIDE, Calif., Feb. 19, 2019 /PRNewswire/ — Today, Denny Cherry & Associates Consulting announced that renowned Microsoft MVP Meagan Longoria is joining the company as a consultant.
A Microsoft Data Platform MVP with over ten years of experience, Meagan specializes in business intelligence, data warehousing, and database development. Her areas of expertise include dimensional modeling, data integration design patterns, and data visualization, a topic she recently spoke about at the Power BI World Tour in Dallas.
CEO and Principal Denny Cherry commented, “Meagan is positively innovative in creating solutions in Azure and SQL Server that make data useful for decision makers. She’s particularly gifted as a Power BI consultant and innovator and has been influential in shaping the product with feature suggestions and feedback to Microsoft’s product team. With Power BI becoming such a critical tool in Azure solutions, she’s a perfect fit with our clients and team.”
Longoria responded, “I’ve known the consultants at Denny Cherry & Associates for years through the SQL Server Community. My chats with them at conferences and on Twitter demonstrated their incredible SQL and Azure knowledge, and I’m excited to learn from them. I feel very fortunate to work for a company that values and encourages participation in the technical community.”
About Denny Cherry & Associates Consulting
Award-winning Microsoft Partner and Gold Platform certified Denny Cherry and Associates Consulting assist companies with reliably attaining IT goals such as Azure Migration, HA, scalability, SQL Server virtualization and acceleration, while finding ways to save on costs. With clients ranging from Fortune 50 corporations to small businesses, their commitment to each is the same: to provide a deft, high-speed IT environment that maximizes every aspect of their platform: from architecture, to infrastructure, to network.
SOURCE Denny Cherry & Associates Consulting
There are those cases when VMs need super fast storage in the cloud. Now Azure has an offering to get you that storage speed. With the introduction of the Lsv2-series of VMs, you can now get NVMe storage on your Azure VMs. Like with the other VM sizes, the more CPU that you purchase, the more storage you can attach to the VM. The size of the NVMe storage is assigned in 1.9TB chunks, with one 1.9TB chunk on the smallest machine (the L8s v2 VM) up to 19TB (19 1.9TB volumes) on the largest machine (the L80s v2 VM).
One big difference that you’ll see of these VMs is that this storage isn’t network attached. Because the storage isn’t network attached this means that the NVMe disks are local to the host, so if the VM moves to another host in the Azure Environment then the data will be gone. The same applies if you power down the VM and deallocate it (basically if you stop paying for it). As soon as the VM is deallocated any data stored on the NVMe disks is gone.
The big question for DBAs is; how do you use these for SQL Server?
Using these Lsv2-series, VMs is going to require some High Availability and Disaster Recovery planning to roll these VMs out. You’ll want to use Availability Zones (if they are in your region) so that you can keep two copies of the data in two different buildings within one region. You’ll also want to set up your database to span across regions as well so that if there’s a site failure, you don’t lose all of the data within the database (remember, on a failure of the VM, the data is gone). Settings this up will require either a Failover Cluster (using SIOS data keeper) or an Availability Group to that your data is stored in multiple data centers. Designing a solution for these new machines is going to require a decent understanding of the hardware that’s behind the machines so that you’ve got a good understanding of what’s happening under the covers with your machines (like the fact that your storage is deleted when you deallocate the machine). Thankfully the experts at Denny Cherry & Associates Consulting can help with designing these environments. Even though these VMs are brand new, we have already evaluated them with our customer’s workloads and have put them in place where it makes sense.
Azure has a feature called Constrained Cores where you can limit the number of cores presented to a VM. This feature gives you all the memory, storage, network bandwidth, etc. for a machine without the SQL Licensing cost of having all the CPUs that you don’t need. Constrained Cores is not available for the Lsv2-series VMs (yet), so you’ll need to do some right-sizing to make sure that you’re using the right size VM for your workload. But even without constrained cores, these VMs are going to be a game changer in the speed of storage for VMs.
The post NVMe Storage in the Cloud using the Lsv2-series Azure VMs appeared first on SQL Server with Mr. Denny.
There are people out there that reboot SQL Servers (or all servers) weekly. Usually the argument that I hear for doing this is that SQL Server has memory leaks which can only be resolved by rebooting Windows.
My argument against this, is that no SQL Server doesn’t have memory leaks which cause it to need to be rebooted weekly. SQL Server is designd to use all the RAM that’s allocated to it. By default SQL Server is configured to use 2147483647 MB of RAM, or all of the RAM in the server. You can and should be changing this setting to a lower number so that there is memory for Windows and anything else that’s installed on the box (anti-virus, SSIS packages, SSAS, etc.). The people that I typically see doing these server reboots, have been doing them for 15-20 years, typically because back then rebooting a server would fix a problem. It won’t anymore.
There are servers that are running SQL Server that have been up for months, or years without issue (I’m ignoring the fact that you aren’t patching SQL Server and Windows here). I’ve persoally seen boxes with pretty heavy workloads on them that have run for years without having to be rebooted.
SQL Server doesn’t have any memory leaks. It’s a world class product of Microsoft, that runs millions of databases (if not more) and makes Microsoft billions of dollars in revenue each year. Whatever memory leak you think there is in SQL Server, there’s probably isn’t. If you think there is, then contact CSS at Microsoft to report the issue as Microsoft needs to patch the problem.
The biggest problem that people will see if that the buffer pool is flushed when the SQL Server restarts, and this causes SQL Server to read all the data it needs from disk as there’s no data in RAM. This causes performance issues right after the restart of SQL Server.
If you’re restarting SQL Server because there’s some performance issues that “goes away” after a SQL Server restart, we’re going to be better off dealing with the root cause of what’s causing the problem to come up to begin with. It’s probably going to be indexing or statistics, but that’s just a guess as every server is different, but it’s probably a safe guess. Looking at the server will tell us what the problem is for sure, so we can solve the problem (and hopefully make the server faster in the process).
The post Should SQL Servers be rebooted weekly appeared first on SQL Server with Mr. Denny.
Today we are proud to announce that Denny Cherry & Associates Consulting is growing our team of consultants again. Our newest team member is Meagan Longoria from Denver, CO.
Meagan is a Microsoft Data Platform MVP living with her adorable dog Buster in Denver, Colorado. She is an experienced consultant who has worked in business intelligence, data warehousing, and database development for over ten years. She enjoys creating solutions in Azure and SQL Server that make data useful for decision makers. Her areas of expertise include data visualization, dimensional modeling, and data integration design patterns.
Meagan enjoys sharing her knowledge with the technical community by speaking at conferences, blogging at DataSavvy.me, and sharing tips and helpful links on twitter (@mmarie).
With the addition of Meagan our team of consultants now includes 5 Microsoft Data Platform MVPs, which is more MVPs than most large consulting companies have.
We’re thrilled to have Meagan joining our team.
The post DCAC Grows Again, Adding Meagan Longoria to our team of Excellent Consultants appeared first on SQL Server with Mr. Denny.