Welcome to Romanian SQL Server User Group Sign in | Join | Help

Browse by Tags

All Tags » Troubleshooting   (RSS)

Show all index and heap access operators in the plan cache

with xmlnamespaces (default 'http://schemas.microsoft.com/sqlserver/2004/07/showplan') select x.value(N'@NodeId',N'int') as NodeId , x.value(N'@PhysicalOp', N'sysname') as PhysicalOp , x.value(N'@LogicalOp', N'sysname') as LogicalOp , ox.value(N'@Database',N'sysname') Read More...
Posted 28 ianuarie 2012 01:42 from rusanu.com | (Comments Off)

SQL Server table columns under the hood

You probably can easily answer a question like ‘What columns does this table have?’. Whether you use the SSMS object explorer, or sp_help, or you query sys.column, the answer is fairly easy to find. But what is I ask ‘What are the physical Read More...
Posted 21 octombrie 2011 01:36 from rusanu.com | (Comments Off)

Understanding Hash, Sort and Exchange Spill events

Certain SQL Server query execution operations are calibrated to perform best by using a (somewhat) large amount of memory as intermediate storage. The Query Optimizer will choose a plan and estimate the cost based on these operators using this memory Read More...
Posted 19 octombrie 2011 22:28 from rusanu.com | (Comments Off)

This server supports version 662 and earlier…

A new error started showing up in SQL Server 2008 SP2 installations: The database cannot be opened because it is version 661. This server supports version 662 and earlier. A downgrade path is not supported. 661 sure is earlier than 662, so what seems Read More...
Posted 23 noiembrie 2010 19:58 from rusanu.com | (Comments Off)

The puzzle of U locks in deadlock graphs

In a stackoverflow.com question the user has asked how come a SELECT statement could own a U mode lock? The deadlock indeed suggests that the deadlock victim, a SELECT statement, is owning an U lock on the PK_B index. Why would a SELECT own an U lock? Read More...
Posted 13 mai 2010 00:15 from rusanu.com | (Comments Off)

The Bizzaro Guide to SQL Server Performance

Some say performance troubleshooting is a difficult science that blends just the right amount of patience, knowledge and experience. But I say forget all that, a few bullet points can get you a long way in fixing any problem you encounter. Is more important Read More...
Posted 31 martie 2010 11:28 from rusanu.com | (Comments Off)

What deprecated features am I using?

Copyright Remus Rusanu 2010. Visit the original article at http://rusanu.com/2010/01/12/what-deprecated-features-am-i-using/   select instance_name as [Deprecated Feature] , cntr_value as [Frequency Used] from sys.dm_os_performance_counters Read More...
Posted 12 ianuarie 2010 21:37 from rusanu.com | (Comments Off)

System pagefile size on machines with large RAM

Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/11/22/system-pagefile-size-on-machines-with-large-ram/  Irrelevant of the size of the RAM, you still need a pagefile at least 1.5 times the amount of physical Read More...
Posted 23 noiembrie 2009 00:33 from rusanu.com | (Comments Off)

Fix slow application startup due to code sign validation

Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/07/24/fix-slow-application-startup-due-to-code-sign-validation/  Sometimes you are faced with applications that seem to take ages to start up. Usually they freeze Read More...
Posted 24 iulie 2009 21:18 from rusanu.com | (Comments Off)

%%lockres%% collision probability magic marker: 16,777,215

Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/05/29/lockres-collision-probability-magic-marker-16777215/  @jrowlandjones blogged about a dubious deadlock case. I recommend this article as is correct and presents Read More...
Posted 29 mai 2009 03:41 from rusanu.com | (Comments Off)

Read/Write deadlock

Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/05/16/readwrite-deadlock/  How does a simple SELECT deadlock with an UPDATE? Surprisingly, they can deadlock even on well tuned systems that does not do spurious Read More...
Posted 16 mai 2009 06:13 from rusanu.com | (Comments Off)

CLR Memory Leak

Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/01/19/clr-memory-leak/  On a recent client engagement I had to investigate what appeared a to be a memory leak in a managed application. The program was running Read More...
Posted 19 ianuarie 2009 15:58 from rusanu.com | (Comments Off)
Filed under:

Replacing Service Certificates that are near expiration

Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/11/26/replacing-service-certificates-that-are-near-expiration/  Service Broker services use certificates for authenticating message origin and for encrypting messages. Read More...
Posted 26 noiembrie 2008 19:41 from rusanu.com | (Comments Off)

Event ID 833: I/O requests taking longer than 15 seconds

Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/10/28/event-id-833-io-requests-taking-longer-than-15-seconds/  The error 833 is usually associated with hardware or system driver problems and the typical recommendation Read More...
Posted 28 octombrie 2008 17:09 from rusanu.com | (Comments Off)
Filed under:

Certificate Not Yet Valid

Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/08/25/certificate-not-yet-valid/  So you are running into a blocking issue, try to find a solution and you gets back a reply like ‘Sorry, I cannot repro Read More...
Posted 25 august 2008 10:28 from rusanu.com | (Comments Off)
Filed under:
More Posts Next page »