Feb 11, 2010 · In Sql Server 2005, is there a way to query the total disk space (physical hard drive(s)) available on the server?

Jun 28, 2016 · The right blocks size should improve the performance of a sql server database. I’m looking for a recommendations and methods to identify which storage blocks size is appropriated for a database. Is there a guide on how to identify an appropriated block size?

Feb 10, 2021 · One of the tasks is to monitor free space on the drives where SQL Server files reside and in this tutorial, we look at a way to easily capture all of this data from all of your instances for easy analysis and reporting.

May 27, 2018 · This article presents six ways to check the size of a SQL Server database using T-SQL. The sp_spaceused Stored Procedure This is a system stored procedure that displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database, or displays the disk space reserved and ...

Jul 7, 2016 · As you know, SQL Server has two main ways of writing to the database files: one is checkpoint, which can issue IOs of anywhere from 64KB to 1MB (up from 256KB max), and the other is the lazy writer process (similar to checkpoint in IO characteristics).

Aug 3, 2020 · Given SQL Server's ability to adjust I/O block sizes based on operation, how does formatting the disk with 64K allocation unit help a read query?

Jul 27, 2011 · We can check the disk space by executing a PowerShell script using xp_cmdshell from SSMS. In order to do this, you need to make sure that xp_cmdshell is enabled on the SQL instance. You can execute the below script to check and enable xp_cmdshell .

Aug 2, 2013 · A very common question I often receive is how to detect if the disk space is running low on SQL Server. There are two different ways to do the same. I personally prefer method 2 as that is very easy to use and I can use it creatively along with database name.

Sep 6, 2017 · Post discussion, the next question was how do we check the disk block size for a given server? You can do it from command line using FSutil utility. But let's do it with PowerShell. Here is the code which I ran to get the block size details.

Sep 27, 2015 · Lets see how we configure Windows as per best practice (SQL Server on Faster disk) and how we create and format SQL Server data partition with desired offset and block size to make it optimize for SQL Server installation.