Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tinamiller1
Yak Posting Veteran
78 Posts |
 Posted - 2015-02-25 : 09:37:37
|
| I ran a query to see how big my database on my SQL Server is and do not understand the metrics. I want to see how much of my 10GB database is left.database_name database_size unallocated spaceANTHEMQ 6521.06 MB 243.55 MBreserved data index_size unused1332304 KB 1328168 KB 1800 KB 2336 KBtina m miller |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-02-25 : 12:29:42
|
| You're interested in the unallocated space info.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
tinamiller1
Yak Posting Veteran
78 Posts |
Posted - 2015-02-25 : 14:08:51
|
| So I have a 10GB SQL Server space which is 10240 MB. So in essence I have about 2GB left. Maybe that is why my large table of 5.5 million rows I just loaded and did my joins and all is running slow. Because I only have 2GB left? Plus I am doing this via my ISP, through VPN and connected live to our SQL Server in Tableau.tina m miller |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-02-25 : 14:18:21
|
| Unless it's autogrowing, it wouldn't affect performance. I'd be suspicious of out-of-date statistics as the culprit of the performance problem, especially since it was just loaded.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
How to determine the size of database