Comments
-
it depends on the settings: Best practice is to set "Restricted File Growth" to a value not to high (to prevent that an irregular action in the database causes that the harddisk run out of space) and not to low (to prevent that the Database run out of space, because the file grows automatically only till the "Restricted…
-
No, because this (%) - Calculation is not calculated to the file size. This (%) - Calculation is a calculation to the "max growth size". For example: test.mdf has a size of 100 Gbyte. In this test.mdf are 71 Gbyte of Data ( indexes included..). The growth size is 100 Mbyte. (but this is irrelevant for this case) The max…
-
Thanks, i understand now, that it is difficult to precalculating the amount of data. I had monitored now already for some months an instance with "Appinsight for SQL". It would be too a help if i can know how many data has occupyed this monitoring for having an idea how "heavy" is Appinsight for SQL... How can i measure…
-
Hello aLTeReGo, i try to explain for my concrete case: I wanna use "AppInsight for SQL". I have ca. 20 central and important MSSQL-Servers and ca. 150 less important SQL - Servers in branch offices (over WAN). I read, that AppInsight for SQL must be used entirely, it is not possible to switch off some counter that i don't…