Tag Info

New answers tagged

11

Each row has a minimum of 7 bytes of overhead when stored in FixedVar format (the default). There will also be a (typically relatively small) number of pages used for the upper levels of the clustered index. Optimally stored, and disregarding the upper index levels, 2 million rows would require just over: (7 + 8 bytes) * 2,000,000 = 28.61MB. More ...


1

You can run a query similar to the following that will show the number of reads and writes for files since SQL Server started. Change the number in line 6 to get stats for different databases. 1 = master, 2 = tempdb, 3 = model, etc. 5 and up will be for your user databases. SELECT files.physical_name, files.name, stats.num_of_writes, ...


0

If the crux of the question is, "How do I get correct data to size my storage subsystem?" and you want to it fairly repeatedly across many servers, use windows performance counters. Here is the list I would minimally have: Logical Disk(*)\Current Disk Queue Length Logical Disk(*)\Disk Read Bytes/Sec Logical Disk(*)\Disk Reads/Sec Logical Disk(*)\Disk Write ...



Top 50 recent answers are included