June 7, 2017 at 6:54 am
Sreejith! - Tuesday, June 6, 2017 11:56 PMI tried to save it to table & alert got triggered again. As I mentioned earlier, D drive is a dedicated drive for TEMPDB and in SSMS available free space is showing as negative values; which is due to issue mentioned in below blog post
https://blogs.msdn.microsoft.com/ialonso/2012/10/08/inaccurate-values-for-currently-allocated-space-and-available-free-space-in-the-shrink-file-dialog-for-tempdb-only/Does it has something to do with xp_fixeddrives procedure???
Unlikely. The linked article sounds like it's a quirk of the UI when looking at tempdb, with XP_FIXEDDRIVES being undocumented we can't know what it's using to get the free space of the drive (which is separate from the size of the DB.)
So, you indicated you tried to store the output in a regular table, what was the value in the table for the D drive?
Viewing post 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply