Datavail is focused on database support for Oracle, Oracle Applications, SQL Server, DB2, MySQL and MongoDB.
From managed services to projects, staff augmentation to 24x7 operational support, Datavail has your databases covered.
As the largest pure play database services company in North America, Datavail’s clients include Fortune 100 to mid-sized companies and startups that rely on 24x7 monitoring and response for critical, revenue-generating database infrastructure.
Up until recently the commonly understood and accepted ideal number for page-life-expectancy (PLE) for a SQL Server instance was 300 seconds (5 minutes) or greater. Recently, the Microsoft rule-of-thumb from the days of SQL 2000 and 4GB RAM is being rethought, some might say debunked.
Jonathan Kehayias offers a good explanation which says in summary, in these days of 16GB, 32GB, 64GB, and above RAM and correspondingly more available memory for the buffer pool, a PLE of only 300 seconds might indicate some significant resource usage and be a cause of concern.
In fact, even back when servers didn’t…
Microsoft has not made any major changes to Replication for the last few versions, but with each version there are always a few changes. I have listed some of the most appealing changes below:
New Feature: Replication support for Availability Groups
Replication has been updated to support AlwaysOn. What this means is there are additional functionality to support the primary changing to a different replica. Extended Events support has been added, but it is not currently useful. New stored procedures were introduced to allow you to redirect the publisher…
Performance tuning any database takes time, patience and some know how. It’s an ongoing challenge for any DBA manager and if not handled with a focused approach, can bring your system to a screeching halt.
I’ve been looking forward to presenting a webinar for awhile on a unique approach to tuning that I’ve honed while working at Datavail, which we refer to as The 5S Approach. I’m proud to say the hope is now a reality and I will get one hour, sans interruptions, where I get to talk about each stage of the process as well as key performance…
Database performance problems are not caused by magic. Indeed, all performance problems are always caused by change. That statement flies in the face of what I normally say, which is “Almost never say always or never”… but in this case, it is true.
Think about it for a moment. If everything remains stable and unchanging in your environment, then why would performance vary? That’s right, it wouldn’t.
Something tangible must change before a performance problem can be experienced. The challenge of performance tuning is to find the source of the change, gauge its impact, and formulate a solution. Change can take…