DBA

SQL server reports GUI Schema change history and CPU  RAM IO

Advertisements

SQL server reports GUI Schema change history and CPU  RAM IO

There are standard reports available in SQL server, we can generate from GUI. It is available from SQL2005 onwards, It is collected from default trace – fn_trae_getdata , since last restart of instance. You can get it from T-SQL or GUI. By default it is enabled.

We can use this for sharing some reports – Top usage, high CPU IO used queries and schema change history who dropped a database, table, schema.

Right click server — Reports — Standard Reports.

Schema change history

I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

Leave a Reply

%d bloggers like this: