dmosley

Results of sizing an index are also relative to the method used to do so, especially when dealing with clustered. If you are estimating index size simply by multiplying 8 * (# of pages) vs using a query joining sys.indexes with sys.partitions or sys.sys.dm_db_partition_stats, you will get wildly differing results (which…

Thanks for your response. I should have mentioned that I did verify that all of the components in the "SQL User Experience" monitors that I am currently using are set to use Windows authentication first. Those servers still manage to have about five failed login attempts logged per hour for whatever reason. Those monitors…