Tag Info

Hot answers tagged

5

Sorry, SQL Server does not track database use. People have come up with not-so-clever ideas like a logon trigger that checks the default database of the login and/or ORIGINAL_DB_NAME(). But this misses all kinds of things like contained users, people who later issue a USE command, cross-database queries, etc. My recommendation is SQL Server Audit if you ...


1

"Does minimizing the size of the database come at a cost of lower performance?" Typically databases are IO limited, unless they are regularly recalculating reporting style queries. (in which case pre-calculated views can be added to again shift cpu to IO.) Minimizing the size of the database typically minimizes the IO needed against the disk, as a higher % ...


1

First of all Thanks Aaron, You're solution worked! Moreover just to add, i also used the tip from Kendra Little's Blog http://www.brentozar.com/archive/2014/05/4-lightweight-ways-tell-database-used/ The 4 tips including Aaron's made me figure out and come to a conclusion for the unused databases, took them offline and no alarms as of now.


1

The amount of memory specified in innodb_buffer_pool_size is allocated when the MySQL Server daemon starts up, and if the system doesn't have that much memory free at that moment, MySQL won't start. The amount of memory you specify is what the buffer pool gets, and it neither grows nor shrinks. InnoDB reads pages from disk into the pool as they are ...


1

Since the production portion of this question hasn't been answered, I have an example of where it would be useful. I'm backing up a production table to my userspace. This table contains a lot of data (~850GB compressed) and backing up through normal means isn't possible because the log file it generates (over 18GB prior to me killing the insert) cause ...



Only top voted, non community-wiki answers of a minimum length are eligible