I’m pretty sure that most of you already struggled with some low performance systems. In order to analyse such cases several tools and utilities, like top, nmon, fuse or lsof are available under Linux. However trying to dig in processes analysis and looking for files and processes relations may be quite painful.
To get started with performance checks and analysis, a interesting utility is available: htop
I have seen at a customer that the SQL Server’s policy doesn’t follow the Microsoft’s recommendations about antivirus and databases(kb 309422), such excluding *.mdf,*.ndf and *.ldf files. In addition the policy for Oracle doesn’t exist in case of Forefront Endpoint Protection 2010 known as FEP 2010.
I have decided to create databases policies for FEP optimized by dbi services to be generic and adapted to all SQL Server and Oracle environments.
Oracle SQL Developer and Data Modeler are becoming more and more popular as they are both cost-free and available on many Operating Systems (Linux/Unix,Windows and Mac) with different installation types: “This zip does not include JRE” or “This zip file includes the JRE”. On linux, the choice is limited because the only version available doesn’t include Java Runtime Environment. And it’s an RPM !! So what… In this post I will provide all information required to install and run these tools on an Ubuntu machine.
Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.
Since few months, I test the future new version SQL Server 2012 codename Denali and I was very surprised form the news DMVs from this version.
I will just explain some DMVs very interesting for a DBA.
My article is based on msdn web site reference and you find in the end from each chapter a msdn reference for more details of the DMV.
Ayant rencontré récemment des problèmes de blocs corrompus sur des bases Oracle en version Oracle 10g et Oracle 11g, des différences notables sont apparues notamment au niveau de la vue v$database_block_corruption. Je vous livre dans ce post le résultat de mes tests.
A few days ago I downloaded the Cloud Control 12c binaries for Linux x86_64 from the Oracle Technet.
My friend, Hervé Schweitzer, configured an OEL 5.7 VM for test purpose and I was quite eager to install this new software. I checked the O.S settings, the required parameters, aso …, everything was fine. My OMS repository database (188.8.131.52) was ready. Unfortunately, as soon as I started the installer, it directly crashed.
Last week, I attended for the first time the Microsoft TechDays. The 2011 Swiss “edition” took place in Bern. For me it is new challenge, because I newer worked deeply with the Microsoft Database Platform “SQL Server”.
During our test to create a failover clustering with the new function ‘AlwaysOn High Availability’, we had a few difficulties to overcome like the restoring of databases of the secondary cluster node.
In this article, we will just explain you how to avoid it before you encounter the problem.