September, 2008

Posts

| |

|

Microsoft SQL Server troubleshooting

SQL Server log growing out of control due Query subscription warning messages (SQLDependency API)

Posted over 4 years ago

by Joao Loureirot_
- 0 Comments
When using a query notification enabled application that is using SqlDependency, if Stop() method is called very frequently, which throws away the machinery for receiving a query notification, but it doesn't actually cancel the subscription. So, when...
Microsoft SQL Server troubleshooting

SQL Server installation troubleshooting, interesting articles

Posted over 4 years ago

by Joao Loureirot_
- 1 Comments
General info, best practices 907284 - Changes to the readme file for SQL Server 2005 910229 - SQL Server 2005 Express Edition Readme 905395 - A change to the Readme.htm file for SQL Server 2005 Mobile Edition 910070 - The SQL Server 2005...
Microsoft SQL Server troubleshooting

How to use Windbg to debug a dump of a 32bit .NET app running on a x64 machine

Posted over 4 years ago

by Joao Loureirot_
- 1 Comments
Imagine we are running a 32bit .NET app in a x64 machine . This app is failing so we have taken a memory dump of the app when a specific CLR exception gets raised. We open the dump with our 64bit version of Windbg ( Windbg x64 ), and we verify that...