culture independent format
network bind order
sql 2008 r2
SQL Server Configuration Manager
SQL Server SQLServer 2008R2
User-Defined Server Roles
Browse by Tags
Tagged Content List
SQL 2012 System health–fast analysis
Once we encounter a few problems with the SQL 2012 and we need to analyze it, what will be the first recommended step to start with? During my last post I have discussed the default trace in SQL and its benefits. SQL 2008 introduced a new option called extended events (which is also know as Xevents...
24 Mar 2013
Check your SQL – default Trace
Every installation of SQL has a default trace. The default trace was introduced in SQL 2005, It is the same trace that we know from the profiler or server but it is a preconfigured trace that is enabled as default. The default trace create five *.TRC file that are been recycle when they arrive to 20...
21 Jan 2013
the case of the unexplained - how we can get different execution plans and result sets for same query
The other day, my colleague and a good friend called me and told that her SQL Server gone nuts. One of developers launched a query and it run for ages, once she executed the same query it returned results in a few seconds. So how something like this can happen ? Each compilation is done for specific...
12 Dec 2012
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 output. ...
4 Dec 2012
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...
4 Nov 2012
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...
26 Aug 2012
Page 1 of 1 (6 items)
© 2013 Microsoft Corporation.
Privacy & Cookies