SqlServer-QA.net

SQL Server has a wealth of Dynamic Management Views (DMVs) to get you health status of the platform. All the data will be extracted with a query, set of transactions and many more ways, in this case you had to be careful with transactions, because whenever so much data was flowing back and forth between the application server and the ...

Every database object will have a sort of dependency between them, such as a stored procedure to run few queries against a table. Similar to this whenever a SP or query is executed then a compiled plan will be generated by the SQL query optimizer, to note about there are two main types of plans in the Object and SQL plan cache stores: ...

One of the primary design goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. SQL Server builds a buffer pool in memory to hold pages read from the database. Much of the code in SQL Server is dedicated to minimizing the number of physical reads and writes between ...

On the subject line the process to find the answer is not a short one! By design SQL Server engine takes care when the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the best indexes do not exist, the query optimizer generates a suboptimal query plan, but still stores ...

The subject line of this post is a common factor that every DBA might have (once in lifetime).  Performance Monitoring is a big subject when it comes to practice,  many factors include such as what to monitor, how often, and 'basic' rules of thumb. For the sake of performance you cannot simply compromise any SLA or Availability of ...

Here is the quirky error that has caused a resources crunch on a SQL instance, Error : Process ID -2 is not a valid process ID. The actual issue occurred during an update to a table that has been used by Online application to update the action log, intially the DBAs have thought it is a blocking problem and trying to catch up the SPID ...

Recently there hasn't been much of SQL Server tasks for me, as most of the time I was involved on designing the solutions for larger installations - a 8 node cluster or VLDB configuration etc. Ok I admit that still it can be classified as SQL Server task but not directly relating to what I used to enjoy the good old ''DBA' days. ...

How many times in a day you observe the TEMPDB in your SQL Server enviornment?  How many times in a week you monitor the TEMPDB in your SQL Server environment? Well, these are not an interview questions to ask and as you aware that because TEMPDB is so much more heavily used in SQL Server 2005 than in previous versions, you have to ...

PERFMON and Resource Governor - two great tools in hand for a DBA to monitor/resolve the performance problems, agreee! Back in olden days you may remember about SQLDiag and PSSDiag, the utility used as a general purpose diagnostics collection utility that can be run as a console application or as a service. Both of these Diag tools are helpful to ...

As a SQL Server user or DBAs using SP_WHO or undocumented stored procedure SP_WHO2 is a common occurrence. For this there are times when you will need to run sp_who on your SQL Server to figure out who is on and what are they doing. The output is quite clear to get a list of processes with SPID, but how about more detailed information on ...