Computing desk | ||
---|---|---|
< April 11 | << Mar | April | May >> | April 13 > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
I've a table which is heavily increasing it's size, despite I can't figure out why. I compared the row count of the table before I went sleep and it's the same count this morning, however the table size has increased 20 GB (4 Autogrowth steps of 5 GB). Also monitoring the table with SQL Profiler doesn't give me an idea what's going on to this table. My first thought was, that perhaps not the data itself has changed/increased, but some metainformation related to the table. So I tried to find out the size of the table index and found this script here ( http://sqlsolace.blogspot.ch/2009/07/tsql-index-size-script.html). The results showed me that the index size is 210 GB which is unbeliveable high since the table size itself is 225 GB. Later I found this command here: exec sp_spaceused @updateusage = N'TRUE'; which also shows the index size. But the result of this command shows a index size of only 70 MB. So I'm not sure who tell me the true, but I prefer the result of the buildin Stored Procedure over the TSQL-Script I found.
However, if it's realy true the index is just 70 MB (not 210 GB) and since the table increses last night 20 GB without increasing in row count, the table must have increased somewhere else. So I'm asking me how big the "Statistics" are. There are 17 statistics, each for every column of the table. But I can't determine how big (physcial store) the statistics are. I searched for a script to determine the statistic sizes, but I din't find some. I found the command 'dbcc show_statistics(tablename, indexname)', but that doesn't show me the physical storage size too. I didn't understand the result at all. But here is one of about 145 rows:
RANGE_HI_KEY RANGE_ROWS EQ_ROWS DISTINCT_RANGE_ROWS AVG_RANGE_ROWS
B9C37EED-0480-4943-8031-03DC069E8633 966.2053 1 965 1.001614
So my question: Is there any command to determine the physical size of an statistic (not the index itself!)?
(For those who like to advice me just to drop the statistic: I can delete the columne statitics, but not the one which I suppose it's the one how is that big, because it's associated with the Primarykey-Index. Error: 'Cannot DROP the index xxxbecause it is not a statistics collection.'. I also thought about to drop the index itself, but a.) I don't really like to perform this, at least I'm not sure it that matter of my problem b.) I can't as even trying rebuild or disabling the index would give a timeout error. It seams there are some locks and I would have to kill the SPID first. But again: Before I drop the statistic and the index, I really would determine the statistic size first)
-- 193.47.149.78 ( talk) 10:34, 12 April 2014 (UTC)
4173600.00%, 4171800.00%, 4172300.00%, 4173600.00%, 4173200.00%... for some reason a bunch of the dates in my spreadsheet have turned into percentages like you see here. Note that employees who aren't me input them, so I'm not sure whether they did something wrong with formatting; I'm just the in-office computery guy so I'm expected to fix it. Is there any way to figure out what dates were originally input in the spreadsheet? (Most of these dates are likely from the past few weeks, and are normally input in 4/11/2014 format) 50.43.180.176 ( talk) 15:09, 12 April 2014 (UTC)
So I went and bought a copy of Windows 8 for my computer since Windows XP won't be supported anymore. However, I don't want to throw away the Windows XP installation forever; I would like to back up an image of my hard drive onto a flash drive before I install the new OS. Can I just copy everything over, or do I need to use imaging software? And if I do need to use imaging software, where can I obtain such software inexpensively? 71.3.50.250 ( talk) 19:54, 12 April 2014 (UTC)
Computing desk | ||
---|---|---|
< April 11 | << Mar | April | May >> | April 13 > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
I've a table which is heavily increasing it's size, despite I can't figure out why. I compared the row count of the table before I went sleep and it's the same count this morning, however the table size has increased 20 GB (4 Autogrowth steps of 5 GB). Also monitoring the table with SQL Profiler doesn't give me an idea what's going on to this table. My first thought was, that perhaps not the data itself has changed/increased, but some metainformation related to the table. So I tried to find out the size of the table index and found this script here ( http://sqlsolace.blogspot.ch/2009/07/tsql-index-size-script.html). The results showed me that the index size is 210 GB which is unbeliveable high since the table size itself is 225 GB. Later I found this command here: exec sp_spaceused @updateusage = N'TRUE'; which also shows the index size. But the result of this command shows a index size of only 70 MB. So I'm not sure who tell me the true, but I prefer the result of the buildin Stored Procedure over the TSQL-Script I found.
However, if it's realy true the index is just 70 MB (not 210 GB) and since the table increses last night 20 GB without increasing in row count, the table must have increased somewhere else. So I'm asking me how big the "Statistics" are. There are 17 statistics, each for every column of the table. But I can't determine how big (physcial store) the statistics are. I searched for a script to determine the statistic sizes, but I din't find some. I found the command 'dbcc show_statistics(tablename, indexname)', but that doesn't show me the physical storage size too. I didn't understand the result at all. But here is one of about 145 rows:
RANGE_HI_KEY RANGE_ROWS EQ_ROWS DISTINCT_RANGE_ROWS AVG_RANGE_ROWS
B9C37EED-0480-4943-8031-03DC069E8633 966.2053 1 965 1.001614
So my question: Is there any command to determine the physical size of an statistic (not the index itself!)?
(For those who like to advice me just to drop the statistic: I can delete the columne statitics, but not the one which I suppose it's the one how is that big, because it's associated with the Primarykey-Index. Error: 'Cannot DROP the index xxxbecause it is not a statistics collection.'. I also thought about to drop the index itself, but a.) I don't really like to perform this, at least I'm not sure it that matter of my problem b.) I can't as even trying rebuild or disabling the index would give a timeout error. It seams there are some locks and I would have to kill the SPID first. But again: Before I drop the statistic and the index, I really would determine the statistic size first)
-- 193.47.149.78 ( talk) 10:34, 12 April 2014 (UTC)
4173600.00%, 4171800.00%, 4172300.00%, 4173600.00%, 4173200.00%... for some reason a bunch of the dates in my spreadsheet have turned into percentages like you see here. Note that employees who aren't me input them, so I'm not sure whether they did something wrong with formatting; I'm just the in-office computery guy so I'm expected to fix it. Is there any way to figure out what dates were originally input in the spreadsheet? (Most of these dates are likely from the past few weeks, and are normally input in 4/11/2014 format) 50.43.180.176 ( talk) 15:09, 12 April 2014 (UTC)
So I went and bought a copy of Windows 8 for my computer since Windows XP won't be supported anymore. However, I don't want to throw away the Windows XP installation forever; I would like to back up an image of my hard drive onto a flash drive before I install the new OS. Can I just copy everything over, or do I need to use imaging software? And if I do need to use imaging software, where can I obtain such software inexpensively? 71.3.50.250 ( talk) 19:54, 12 April 2014 (UTC)