By Franck Pachot . When Diagnostic Pack is disabled, either because you don’t have Diagnostic Pack or you are in Standard Edition, I highly recommend to install Statspack. When you will need it, to investigate on an issue that occured in the past, you will be happy to have it already installed and gathering snapshots. I order to be sure…
By Franck Pachot . When we give our trainings (dbi services workshops) we signal our best practices with this logo. It’s our know-how, acquired through experience, consulting, service desk, exchange at events, beta testing, etc. that we share with our customers. Let’s have a look at a few points that we recommend to change if you provision a database with…
Companies are struggling with SharePoint. It’s been installed, and abandoned. Business stuff is not drove to make SharePoint succeed. From this point you need to dress up a governance for SharePoint. Governance focuses on the technology, business and human side of SharePoint. What is GOVERNANCE? Governance is the set of: policies roles responsibilities processes that help and drive Companie’s IT…
Since version 12, ODA stores databases on ACFS volumes instead of ASM directly. This slightly changed the way the files are managed and administer. This articles presents how to multiplex your control files on ACFS. At first database creation, ODA set up 3 ACFS volumes to store all non-CDB databases (CDB are managed on dedicated volumes): /dev/asm/datastore-386 62G 5.2G 57G…
SharePoint performance is a recursive problem and preoccupation. As a Database Administrator, we have to deal with SharePoint when configuring SQL Server databases. In this article, I will propose a list of best practices in SQL Server settings aimed to reduce SharePoint performance issues. This article is inspired from the presentation Optimizing SQL Server for Speedy SharePoint by Sahil Malik…
