SSMS 19.0 Is Available
Glenn's SQL Server Performance Blog
by Glenn Berry
1w ago
Introduction On January 26, 2023, Microsoft released the RTM build of SQL Server Management Studio 19.0. You can download it here. The release notes are here. If you are using a modern version of SQL Server in any capacity, you are going to want SSMS 19.0. This includes “regular” SQL Server, Azure SQL Managed Instance and Azure SQL Database. SSMS 19.0 is fully aware of SQL Server 2022, and it is also officially supported on SQL Server 2014 and newer. It will probably mostly work on older versions of SQL Server, but I have not tested that yet. You can run SSMS 19.0 side by side with SSMS 18.xx ..read more
Visit website
Presenting Dr. DMV On January 11, 2023
Glenn's SQL Server Performance Blog
by Glenn Berry
3w ago
I will be presenting Dr. DMV’s Troubleshooting Toolkit online for the Redmond SQL User Group at 5:30PM Pacific Time on January 11th, 2023. For this session, I will be using the SQL Server 2022 version of my free Diagnostic Information Queries, which have a number of new SQL Server 2022 specific queries. This will still be a useful session if you are on an older version of SQL Server, since most of these queries work on SQL Server 2019 and older. BTW, I update my Diagnostic Queries every month. This blog post talks about the latest version: SQL Server Diagnostic Information Queries for January ..read more
Visit website
SQL Server Diagnostic Information Queries for January 2023
Glenn's SQL Server Performance Blog
by Glenn Berry
1M ago
Introduction These are my SQL Server Diagnostic Information Queries for January 2023, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a relatively short amount of time. This post is about my SQL Server Diagnostic Information Queries for January 2023. There are separate versions of these T-SQL queries for SQL Server 2005 through SQL Server 2022. I also have separate versions for Azure SQL Managed Instance and Azure SQL Database. My diagnostic queries have been used by many people around the world ..read more
Visit website
SQL Server Diagnostic Information Queries for December 2022
Glenn's SQL Server Performance Blog
by Glenn Berry
2M ago
Introduction These are my SQL Server Diagnostic Information Queries for December 2022, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a relatively short amount of time. This post is about my SQL Server Diagnostic Information Queries for December 2022. There are separate versions of these T-SQL queries for SQL Server 2005 through SQL Server 2022. I also have separate versions for Azure SQL Managed Instance and Azure SQL Database. My diagnostic queries have been used by many people around the worl ..read more
Visit website
Is the Samsung 990 PRO Any Good?
Glenn's SQL Server Performance Blog
by Glenn Berry
2M ago
Samsung recently released the highly anticipated Samsung 990 PRO M.2 NVMe PCIe 4.0 SSD. The 990 PRO is the successor to the very popular Samsung 980 PRO M.2 NVMe PCIe 4.0 SSD. This post will investigate whether the Samsung 990 PRO is any good or not. How Much Do These Drives Cost? The Samsung 990 PRO is pretty pricey right now compared to other older high-end PCIe 4.0 SSDs. 2TB Samsung 990 PRO on Amazon 2TB Samsung 980 PRO on Amazon 2TB SK Hynix Platinum P41 on Amazon BTW, these are Amazon Affiliate links. Is the Samsung 990 PRO Any Good? The obvious answer is yes! Objectively, the new Samsu ..read more
Visit website
Hardware Instruction Support in SQL Server 2016
Glenn's SQL Server Performance Blog
by Glenn Berry
3M ago
Introduction Back in 2016, Microsoft’s Bob Dorr consolidated a series of CSS posts about many low-level performance improvements in SQL Server 2016. One of these, How It Works: SQL Server 2016 SSE/AVX Support talks about how SQL Server 2016 added the use of SSE and AVX instructions in various code paths to improve performance when your processor supports one of those instruction sets. This post will review Hardware Instruction Support in SQL Server 2016. You might be thinking this is not relevant anymore, since SQL Server 2016 is pretty old, and is out of Mainstream Support ..read more
Visit website
SQL Server Diagnostic Information Queries for November 2022
Glenn's SQL Server Performance Blog
by Glenn Berry
3M ago
Introduction These are my SQL Server Diagnostic Information Queries for November 2022, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a relatively short amount of time. This post is about my SQL Server Diagnostic Information Queries for November 2022. There are separate versions of these T-SQL queries for SQL Server 2005 through SQL Server 2022. I also have separate versions for Azure SQL Managed Instance and Azure SQL Database. My diagnostic queries have been used by many people around the worl ..read more
Visit website
Microsoft SQL Server 2022 Resources
Glenn's SQL Server Performance Blog
by Glenn Berry
3M ago
Introduction Microsoft SQL Server 2022 is going to be released pretty soon now. Don’t ask me the exact date, because I don’t know. Even if I did know, I would be under an NDA and an embargo. The official release date is still publicly stated as “before the end of CY2022”. With that in mind, here is my list of Microsoft SQL Server 2022 Resources. The reason that this is relevant is because it is a good idea to start becoming more familiar with the new features and improvements in SQL Server 2022 so you can decide whether it makes sense for your organization or not. If anyone has any additions ..read more
Visit website
SQL Server Diagnostic Information Queries for October 2022
Glenn's SQL Server Performance Blog
by Glenn Berry
4M ago
Introduction These are my SQL Server Diagnostic Information Queries for October 2022, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a relatively short amount of time. This post is about my SQL Server Diagnostic Information Queries for October 2022. There are separate versions of these T-SQL queries for SQL Server 2005 through SQL Server 2022. I also have separate versions for Azure SQL Managed Instance and Azure SQL Database. My diagnostic queries have been used by many people around the world ..read more
Visit website
50GB/Sec with an X670E Motherboard!
Glenn's SQL Server Performance Blog
by Glenn Berry
4M ago
Introduction I recently bought an ASUS ROG Crosshair X670E Extreme motherboard along with an AMD Ryzen 9 7950X processor. This will be the basis of a new main desktop system for me, but I am going to play with it for a bit first. One thing I am going to try is to see if I can break 50GB/Sec with an X670E Motherboard! ASUS ROG Crosshair X670E Extreme This may not be possible with PCIe 4.0 NVMe SSDs, but I want to see how close I can get… What I mean here is 50GB/sec of simultaneous sequential reads as measured by CrystalDiskMark. There will be one copy of CDM running against each M.2 NVMe SSD i ..read more
Visit website

Follow Glenn's SQL Server Performance Blog on Feedspot

Continue with Google
OR