Memory Optimization Archives - {coding}Sight https://codingsight.com/category/database-administration/memory-optimization/ Blog for SQL Server DBAs and Developers Mon, 31 Jul 2023 09:30:48 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png Memory Optimization Archives - {coding}Sight https://codingsight.com/category/database-administration/memory-optimization/ 32 32 Get Your SQL Server Database Size with Ease: Stored Procedures in Action https://codingsight.com/stored-procedure-to-get-server-storage-information-in-server/ Mon, 27 Sep 2021 08:24:33 +0000 http://codingsight.com/?p=17145 As popular as the cloud services are nowadays, there’s still a good chunk of on-premises deployments of SQL Server that still require our services to support them. One of the areas of on-premises setups that we must keep an eye on is storage, right where the data is saved. I’m going to present you a …

The post Get Your SQL Server Database Size with Ease: Stored Procedures in Action appeared first on {coding}Sight.

]]> Workplace Encounters: Reclaiming Space from an Oversized Database https://codingsight.com/basic-post/ Thu, 02 Sep 2021 01:37:34 +0000 http://codingsight.com/?p=15367 INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd April 2015 and 23z April 2015. The details are specific to an application, but the principles may be useful to others in need of doing similar operations in production. KGROUND The database had grown to over 1.44TB …

The post Workplace Encounters: Reclaiming Space from an Oversized Database appeared first on {coding}Sight.

]]> In memory Tables (OLTP) in Microsoft SQL Server Databases with Examples https://codingsight.com/in-memory-oltp-top-10-points-for-beginners/ https://codingsight.com/in-memory-oltp-top-10-points-for-beginners/#comments Thu, 29 Apr 2021 12:44:51 +0000 http://codingsight.com/?p=13004 What if 1 second of a transaction process is too long? You can tune your queries. But what if it’s not enough, can you still step up your game? In-memory OLTP may be the answer. The current article will focus on this SQL Server’s technology for optimizing transaction processing. In particular, we’ll examine the following points: Fasten the …

The post In memory Tables (OLTP) in Microsoft SQL Server Databases with Examples appeared first on {coding}Sight.

]]> https://codingsight.com/in-memory-oltp-top-10-points-for-beginners/feed/ 2 Workplace Encounters: Reclaiming Space from an Oversized Database https://codingsight.com/workplace-encounters-reclaiming-space-from-an-oversized-database/ Fri, 21 Aug 2020 11:02:25 +0000 https://codingsight.com/?p=9760 INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd April 2015 and 23rd April 2015. The details are specific to an application, but the principles may be useful to others in need of doing similar operations in production. BACKGROUND The database had grown to over 1.44TB …

The post Workplace Encounters: Reclaiming Space from an Oversized Database appeared first on {coding}Sight.

]]> Implementing Paging Using OFFSET FETCH NEXT in SQL Server https://codingsight.com/implementing-paging-using-offset-fetch-next-in-sql-server/ Fri, 14 Sep 2018 15:09:28 +0000 https://codingsight.com/?p=5257 A database can have hundreds of thousands of records. It is easy to insert and select these records via database management systems like SQL Server or MySQL etc. However, it is not easy to display thousands of records on a single webpage or in a desktop application. Space and memory constraints make it difficult to …

The post Implementing Paging Using OFFSET FETCH NEXT in SQL Server appeared first on {coding}Sight.

]]> Planning of Disk Space for Databases https://codingsight.com/planning-of-disk-space-for-databases/ Fri, 25 May 2018 14:43:40 +0000 http://codingsight.com/?p=3086 Do you think about something when you create a new database? I guess that most of you would say no, since we all use default parameters, though they are far from being optimal. However, there is a bunch of disc settings, and they really help to increase system reliability and performance. We won’t speak of …

The post Planning of Disk Space for Databases appeared first on {coding}Sight.

]]> Understanding the Importance of Memory Setting in SQL Server https://codingsight.com/understanding-the-importance-of-memory-setting-in-sql-server/ Tue, 13 Mar 2018 12:21:43 +0000 http://codingsight.com/?p=3529 Memory is one among the resources forming the performance triangle—CPU and storage being the other two. If one is hit, the other two take the load to try to bring the performance to acceptable levels, but there’s always the trade-off. Whatever transactions cannot be committed to the memory they would be forwarded to the disk …

The post Understanding the Importance of Memory Setting in SQL Server appeared first on {coding}Sight.

]]> Using Indexes in SQL Server Memory-Optimized Tables https://codingsight.com/using-indexes-in-sql-server-memory-optimized-tables/ Tue, 16 Jan 2018 10:49:43 +0000 http://codingsight.com/?p=3109 Introduction In this article, we will discuss how different types of indexes in SQL Server memory-optimized tables affect performance. We will examine examples of how different index types can affect the performance of memory-optimized tables. To make the topic discussion easier, we will make use of a rather large example. For the purposes of simplicity, …

The post Using Indexes in SQL Server Memory-Optimized Tables appeared first on {coding}Sight.

]]> In Search of Fast Local Storage https://codingsight.com/in-search-of-fast-local-storage/ https://codingsight.com/in-search-of-fast-local-storage/#comments Tue, 21 Mar 2017 14:41:57 +0000 http://codingsight.com/?p=833 Recently, I was involved in the development of the functionality that required a fast and frequent transfer of large volumes of data to disc. In addition, this data was supposed to be read from disk from time to time. Therefore, I was destined to find out the place, the way and the means for storing …

The post In Search of Fast Local Storage appeared first on {coding}Sight.

]]> https://codingsight.com/in-search-of-fast-local-storage/feed/ 1 Creating and Accessing In-Memory OLTP Databases and Tables https://codingsight.com/creating-and-accessing-in-memory-oltp-databases-and-tables/ Mon, 16 Jan 2017 13:44:40 +0000 http://codingsight.com/?p=393 This is the second article in a series of articles about SQL Server In-Memory OLTP. The introductory article — SQL Server In-Memory OLTP, briefly introduced the basics of the new Hekaton engine. In this part, we will focus on practice. To be more specific, we will see how to create In-Memory optimized databases and tables, …

The post Creating and Accessing In-Memory OLTP Databases and Tables appeared first on {coding}Sight.

]]>