84GB data hosted on a SQL Server with 16GB RAM. (Max memory size and file sizes are discussions for another blog post.) Meaning, if it’s hosting 100GB of data, it has 19GB RAM in the server. The median SQL Server has 19% of the data size as RAM. I took last Thursday’s data for about 1,400 servers, then excluded stacked instances (multiple instances installed on the same OS), Azure SQL DB, Managed Instances, and servers with less than 10GB of data. When I look at a SQL Server, one of the first things I check is, “How much memory does this thing have relative to the amount of data we’re hosting on here?” I’ve long used some seat-of-the-pants numbers, but armed with data from SQL ConstantCare® users who opted into public data sharing, let’s do a little deeper analysis.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |