As a database administrator, you need to know the features of the storage that you want to use for your databases. You don’t want …
Read More »Data Collector, Management Data Warehouse, Perfmon
Data Collector is a feature introduced in SQL Server 2008. A nice technology to monitor and report the performance of SQL Server systems. We …
Read More »How To Recreate the Enterprise Manager Repository
Mostly, Enterprise Manager has problems with repository. Because it takes a long time to detect and resolve problems, it will be shorter to recreate. …
Read More »How To Manage Utility Control Point
I recommend reading “How To Monitor SQL Server with Utility Control Point” and “How To Add an Instance To The Utility Control Point” to …
Read More »How To Add an Instance To The Utility Control Point
We installed the utility control point on an instance in the article “How To Monitor SQL Server With Utility Control Point“. In this article, …
Read More »How To Monitor SQL Server With Utility Control Point
Utility Control Point works in an integrated manner within SQL Server and is used to monitor SQL Server. I can say that it is …
Read More »How To Recreate Exadata Flashdisk and Flashcache
You can drop and re-create flash disks and flash cache on Exadata cellnodes online. You will need this process if the flash cache is …
Read More »How to Authorize a User on WMI
When you want to monitor “SQL Server” servers with a monitoring tool, you must grant the user who will monitor access to WMI. To …
Read More »Effects of Very Frequent Growth and Shrink Operations on Automatic Memory Management(AMM)
In Oracle databases, when the Automatic Memory Management (AMM) is active, if the memory values grow and shrink too frequently, wait events can be …
Read More »Identitiy Insert On SQL Server
You need to know about Primary Key and Foreign key before you can read this article. You can read the article “What is Primary Key …
Read More »