Tag: performance

SQL Server 2016 ‘It Just Runs Faster’

TweetIt will need guts to release such a statement, that too announcement about SQL Server 2016 – it just runs faster. Not a simple statement for marketing purpose, but real-world improvements and hard-work efforts made the new version 2016 as…

Edinburgh SQL Server Usergroup Nov 2015 schedule – learn from #SQLSentry pros. #sqlpass

TweetHere is the exciting news for Edinburgh SQL Server usergroup (T: @sqlscot)for this November 2015 schedule. On 12th November we are inviting 2 professionals from SQL Sentry, John Martin (T: @sqlservermonkey) & Richard Douglas (T: @sqlrich). Full abstract and details…

SSMS – Proactive Management Tools in a Single Console

TweetHow to keep up data platform predictable performance? Is it possible to have a built-in capabilities that help make performance more consistent and predictable? No doubt to say an exponential growth within server consolidations and multi-tenant data platforms managed within…

MySQL Series: Performance Engineering – Find What

TweetIn the post MySQL Series: Performance Engineering – Find What I had mentioned about the problem statement, and how I planned to go about it. I had series of areas that I need to attend to stabilize the performance and…


Get your free eBook to find out root cause for the performance problems with your application when ASP.NET and SQL Server is involved.

The offer is available from Red-Gate software 

Free eBook: 50 Ways to Avoid, Find and Fix ASP.NET Performance Issues

eBook download.


Free trial: root out ASP.NET & SQL Server performance problems with ANTS Performance Profiler

ANTS Performance Profiler boxshot

  • Analyze your code and queries side-by-side in a single profiling session.
  • See exactly how your code makes database queries and how those queries perform.
  • Pinpoint the problem fast with full performance data in one place – never switch between a .NET code profiler and SQL Profiler again.

Cumulative Update 2 for SQL Server 2012 SP1

TweetHere is the considerable effort you need to put up to download, test and implement cumulative update package and that is announcement from SQL Server Release Services – Cumulative Update 2 for SQL Server 2012 SP1. KBA2790947 talks much about the…

SQL Server configration settings – MAXDOP, to be or not to be?

TweetAs a DBA parallelism or MAXDOP terms do not need any special introduction, but it is highlgy essential to keep up the necessary settings (default value is 0) on your data platform. In many cases MAXDOP helps to achieve optimization…