Working with SQLIO and analyzing it’s output

Introduction While working on a customer request, I faced the question what is the SQLIO? how to operate it and how to analyze its outputs? The customer has read about the tool and was also able to run it but wanted more information on how to do it and how to easily analyze the SQLIO…

6

SQL Server 2012 new feature The Snippets

Snippets In SQL 2012 we have a new feature called snippets; So what are this snippets? Lots of DBAs, when required to create a new T-SQL command, check out the syntax in BOL, they try to remember on how to do it, Or sometimes we need a repeating T-SQL Command like: Select, Proc, Func, triggers,…

3

PERFMON & SQL Server – a small useful tip

One of the best Performance tools that I use is the PERFMON. PERFMON is a tool that exists out of the box on every windows machine and has lots of counters for almost every application. Perfmon provides current, accurate information on thousands of different attributes of your system. If you open the PERFMON in windows…

0

Stop using TOP to page for data from now on use the OFFSET

  With all the innovation that SQL 2012 bring to us in the T-SQL area we have the offset command. What is the offset command? I early version of SQL (before 2012) when we wanted to select out of a table a number of row we all have used the TOP command, the top command…

0

SQL Server 2012 Audit Enhancements

SQL Server Auditing is useful for auditing the usage of your database operations. We’ve got quite a bit of new features and enhancements in SQL Server 2012. First, server level auditing is now available in all SQL Server 2012 editions. Database level auditing is available only in Enterprise, Developer and the Evaluation editions. SQL Server…


User-Defined Server Roles – new server option in SQL Server 2012

Along with Organization growth and databases growth we need more specific permissions for DBAs, operations and development teams. Starting SQL Server 2005 we can grant server permissions on a more granular level, for example “view server state” and “alter trace”. In SQL Server 2005 and 2008 we are able to grant a new server level…

1

HBA, Queue Depths and inflight IO.

  I had recently received a question form one of my customers asking what is the recommended Queue Depths value for the HBA adapter. This question was intriguing and drove me to do a little research on the subject; I’d like to share the information with you all. Well, all the major/big organization are deploying…

0

Four Tips for SQL Tuning for SharePoint Part 3 TEMPDB

    One of the focal points in SQL Server Tuning for SharePoint is around the TEMPDB. A lot of performance issues are caused by the performance of the TEMPDB. TEMPDB is one of the four system databases. Master is the database that contains all the information about the configuration of the SQL Instance. MSDB…

2

Target Recovery Time – new database option in SQL Server 2012

  Recently I’ve created a new database on my SQL Server 2012 instance. I reviewed the new database options before creating. One of the options that I’d like to share today is “Target Recovery Time” in seconds or TARGET_RECOVERY_TIME. Target Recovery Time is new in SQL Server 2012. This option helps us to control checkpoints…