Tags » SQL Performance

SQL SERVER - How to use Procedure sp_user_counter1 to sp_user_counter10

There are many performance counters available in SQL Server which can be used to monitor various parameters of SQL Server engine. Have you ever been into a situation where you want to see value in performance counter for a query which you have returned? 507 more words

SQL Authority

Database Mirroring Time-Out Mechanism

Error: 1479, Severity: 16, State: 2

The mirroring connection to “TCP://ComputerName:PortNumber” has timed out for database “DatabaseName” after 10 seconds without a response. Check the service and network connections. 436 more words

Sql Server

SQL SERVER - Performance Counter Missing: How to Get Them Back?

Of the thousands of mails I receive every day about SQL Server problems, I was recently pinged by a friend who reported a weird problem. He started with a simple question. 459 more words

SQL Authority

When there needs to be a change to the 'standard configuration'

What do you do when a client complains about slow running queries, but when you suggest changing Maximum Degree of Parallelism to something other than “1″, you are told, “That is our standard configuration. 131 more words

Sql Server

SQL SERVER - Do You Know Your Data’s Classification? - Notes from the Field #050

: Data is a very simple word, yet it is very powerful. There is a famous saying – Know Your Data. I have quite often found that developers do not know their data, they are often confused with the same and not sure how to answer that. 357 more words

SQL Authority

Technical Note on Using #SQLTXPLAIN Through a Proxy User

This is a technical note about using database proxy users with SQLTXPLAIN. 178 more words

SQL Knowledge