| A community of more than 1,600,000 database professionals and growing |
| | | Fitting Into RAM RAM has always been a fairly limited resource in most of the computer systems I've worked with in my career. Often there is never enough RAM, and I'd always like more, often to speed up the systems. That has somewhat changed with laptops, as 16 GB really works well for me most of the time. Not that I wouldn't take a 32GB machine, but I'm waiting for them to become more common and smaller. This has especially been true for database servers. It seems that I've rarely had a database server that could fit my entire database in RAM. Even now, I have an over-provisioned server for SQLServerCentral which has plenty of spare capacity, but I'm still slightly short on RAM. The target level for SQL Server is about one GB more than I have set. Not really worth complaining about, but still I don't have the RAM I'd like. Last week I wrote about someone that attacked the RDBMS as old and troublesome technology. As a part of this, a method of storing all data in memory was presented. I'm not sure I think this is actually a good or practical idea for most systems, but I did wonder about the idea of data space and size. Certainly I have seen plenty of index space in databases, and certainly there is more index data than other data at times, but I suspect that's not the case for many databases. Regardless, I was curious if anyone has large databases that couldn't fit into RAM these days. If you think about the largest database you have, how big is it, in terms of data size. Not allocated size, but the total data space used. Would this fit into RAM if you could get 1TB or 2TB of memory? If you can, what about index sizes, are they large? There are a few scripts in this thread if you need one. I suspect there are certainly databases that don't fit into RAM, and likely plenty of instances with more than 1 database that don't have enough RAM. I still see plenty of people with less than 64GB on their servers, so that's a battle still being fought. I certainly wouldn't advocate an in-memory only database, likely because there are going to be other issues, but it's still an interesting thought. Certainly my server has only 60GB allocated and the databases are well over that in aggregate. Maybe asking for a bit more RAM on those critical servers is the way to go, especially if you think you can get the entire database into memory. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.5MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | | Become a more efficient SQL developer with SQL Prompt Learn how to write SQL faster and more efficiently with these exclusive short videos from Data Platform MVPs and SQL Server experts. With SQL Prompt you can strip out the repetition of coding and write SQL 50% faster. Check out the tips |
|
|
|
| | | | | Additional Articles from MSSQLTips.com In this tip we look at a new feature in SQL Server Reporting Services that allows users to leave comments about reports. More » |
| | Grant Fritchey from SQLServerCentral Blogs Four years ago, after a bunch of dithering and some negotiations with Tony Davis, my editor, I started to update... More » |
| | Steve Jones from SQLServerCentral Blogs One of the more annoying things I’ve found in SSIS/SSMS is trying to import CSV files for some quick analysis.... More » |
|
|
| | | Today's Question (by David Fundakowski): What will the output be of the following: DECLARE @string NVARCHAR(max) = ( SELECT REPLICATE(N'X', 9000) ) SELECT DATALENGTH(@string) |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | Extract, Transform, and Load with SQL Server Integration Services: With Microsoft SQL Server, Oracle, and IBM DB2 Readers will learn by example how to use Microsoft SQL Server 2016 Integration Services (SSIS) as they design and implement extract, transform, and load (ETL) solutions to support a business application that integrates with a data warehouse and an online Web store across a heterogeneous system. This volume describes proven methods to support common ETL needs, such as databases communicating directly with each other, using files to exchange data, or performing database operations using Web services. Pick up your copy of this great book today at Amazon today. |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): The first SELECT statement below returns 10 rows. What is returned by the second SELECT? SELECT top 10 * FROM dbo.UserConfig AS uc go SET IMPLICIT_TRANSACTIONS ON GO TRUNCATE TABLE dbo.UserConfig GO SELECT top 10 * FROM dbo.UserConfig AS uc
Answer: An empty set Explanation: The SET IMPLICIT_TRANSACTIONS ON statement creates a transaction when certain statements are run. The TRUNCATE TABLE starts a transaction, and since it is not rolled back, the second SELECT statement returns an empty set. Ref: SET IMPLICIT_TRANSACTION - click here » Discuss this question and answer on the forums |
|
|
| | | Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. Obfuscating values (via T-SQL) in several Varchar, Char, and Datetime columns ? - Is there any good T-SQL solution that you can recommend for obfuscating a dozen of Char and Varchar fields in... JSON AUTO, WITHOUT_ARRAY_WRAPPER not returning all the columns - Hi I have this View with these fieldsSELECT FisrtName ,LastName ,IDNumber ,Address1 ,Address2 Database file size grew dramatically after deleting/recreating column and populating with data - 1. We have a table, which has about 12,000,000 records. When I ran a Disk Usage by Top Tables report... Error opening Visual Studio SQL Server Solution - Another user and I have the same exact version of Visual Studio but when they try to open a Solution... SQL Server Availability Group - Adding Database to a Group - Hi All Quick question, we're migrating onto an infrastructure with SQL Server Availability groups, and we have one large database we'd... Cost Threshold For Parallelism - Your opinion - Hi, I'm not going to ask what its for or anything, I understand it and its whole history back to Nick's... sp_DatabaseRestore - Hi, I'm just curious if others use sp_DatabaseRestore from Brent Ozar's First Responder's Kit. If so, are you having any issues... Converting XML in ntext field to columns/rows - Hi All, I've been working on this a few days and I'm stuck. I have field (I can't change) that is... On-premises SQL server - adding secondary node to azure VM - Hi all, Am trying to figure out how to add a secondary replica always on to my on-premises SQL server, the... Top amount invoiced query help! - CREATE TABLE Test ( Name varchar(255), InvDt varchar(255), Typeflag integer, amountI integer, amountP integer ); INSERT INTO Test (Name, InvDt, Typeflag,amountI,amountP) VALUES ('man1', '01/01/2018', 1,9000,6000); INSERT INTO... Is there a better way to write a simple query? - This is pretty typical SQL Code for me: -- SET NOCOUNT ON added to prevent extra result sets from -- interfering... View - failed because it contains a derived or constant field. - I have this View: Create View xyz As Select Value, MAX(Case When Other = 'Color' Then Description Else '' End) Color, MAX(Case When Other = 'Font' Then... Lots of ASYNC_NETWORK_IO for SQL Server 2012 - Dear Everyone I am not a performance expert so i needed help in resolving the following item. I ran the... Buffer Cache Hit Ratio - PLE - Dear Experts I noticed a strange thing on some of our databases. When I wanted to get the values for Buffer... The Service Broker endpoint is in disabled or stopped state - I have a SQL 2012 Enterprise edition HADR cluster with 2 nodes and my event log on the second node... Delete Performance: Disable vs Drop constraints - Hello I'm doing a huge task of deleting data in a large table of 300 million rows. This table contains 5 Foreign... Initial size of the database file using T-SQL - Hi, Please let me know how to get the initial size of the database file using T-SQL. sys.master_files, sys.database_files, sysfiles, sysaltfiles... Test Driven Development - I'm trying to incorporate TDD principles into my daily work, but I'm winging it on my own, so looking for... COMPRESS and DECOMPRESS - A short look at these T-SQL functions nad where/how to use them. Examples of compression are useful Hide multiple Columns based on Parameter value in SSRS 2004 - Can anybody tell me how to hide/show multiple columns based on multivalued parameter. ex :i have two parameters 1)item 2)option(multivalued - ven,itm,qty)... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
