ytoledano

28 reputation

	28 reputation	bio	website		visits	member for	1 year, 8 months
5 badges		location			seen	Apr 23 at 22:17

12 Actions

Mar 21	awarded	Popular Question
Feb 9	comment	How much memory is needed to keep a table cached? (SQL Server 2008) I eventually upgraded the RAM of the server and did a test. I posted the results as an answer below.
Feb 8	answered	How much memory is needed to keep a table cached? (SQL Server 2008)
Feb 8	comment	How much memory is needed to keep a table cached? (SQL Server 2008) I upgraded the server RAM and "ballpark the size of the table on disk as the amount of memory" is absolutely correct. See my answer below.
Feb 8	awarded	Scholar
Feb 8	awarded	Supporter
Feb 8	accepted	How much memory is needed to keep a table cached? (SQL Server 2008)
Sep 15	awarded	Editor
Sep 15	revised	How much memory is needed to keep a table cached? (SQL Server 2008) added 1063 characters in body
Sep 15	awarded	Student
Sep 15	comment	How much memory is needed to keep a table cached? (SQL Server 2008) I'll try: SET STATISTICS IO ON and report back. More info: The queries are 100% selects. Each query takes several minutes. The server also runs the small app which does the querying and dumps results into Excel, but I doubt this affects server performance.
Sep 14	asked	How much memory is needed to keep a table cached? (SQL Server 2008)