Welcome to MSDN Blogs Sign in | Join | Help

May 2009 - Posts

Friday, May 29, 2009 6:30 PM

How It Works: SQL Server Timings and Timer Output (GetTickCount, timeGetTime, QueryPerformanceCounter, RDTSC, …)

A series of questions related to start time, duration, end time, T-SQL waitfor delay command and others crossed my path again this week.     As I was trying to explain it to a fellow engineer and I realized it has become a bit complicated.
Posted by psssql | 1 Comments
Filed under: , , ,
Tuesday, May 26, 2009 10:43 PM

How It Works: SQL Server Engine Exception Handling

I was recently asked how SQL Server handles exceptions in the core code of the engine. I looked around at various references and did not find a concise document. When an exception is encountered in SQL Server error details such as the following are inserted
Posted by psssql | 1 Comments
Filed under:
Thursday, May 21, 2009 6:57 PM

How a log file structure can affect database recovery time

We frequently come across situations where databases take a long time to recover. A common scenario is where the recovery process has to roll forward or back several transactions for a database after a SQL Server restart. However, you might also see one
Posted by psssql | 3 Comments
Filed under: ,
Tuesday, May 19, 2009 2:43 PM

An update for Standard SKU Support for Locked Pages….

Note this article has been updated to include an update for SQL Server 2005 I posted in April that we would be releasing cumulative updates for SQL Server 2008 and 2005 to support the concept of Locked Pages for SQL Server Standard. SQL Server 2008 Cumulative
Posted by psssql | 3 Comments
Tuesday, May 19, 2009 5:35 AM

SQL Server Support Policy for Failover Clustering and Virtualization gets an update…

Last October I posted on our updated policy for support of SQL Server in a virtualization environment. This policy is based on a KB article that summarizes our policy. You recall this article is the following: Support policy for Microsoft SQL Server products
Posted by psssql | 6 Comments
Monday, May 18, 2009 5:53 PM

Upgrading Windows with RS 2005

From an IIS perspective, there were changes between IIS 6 (Windows 2003) and IIS 7 (Windows 2008).  Reporting Services 2005 utilizes IIS for the Report Manager and Report Server Web Service.  If you had a Windows 2003 Server with Reporting Services
Posted by psssql | 1 Comments
Friday, May 15, 2009 5:00 PM

How It Works: DBCC MemoryStatus Locked Pages Allocated and SinglePageAllocator Values

I have recently had several questions related to the dbcc memorystatus and associated memory DMV display values for locked pages and single page allocations.   After reviewing several outputs and the code I will attempt to summarize my findings.
Posted by psssql | 1 Comments
Filed under: , , ,
Tuesday, May 12, 2009 5:46 AM

SQL Server reports working set trim warning message during early startup phase

In the previous posts we have discussed the working set trim message “ A significant part of sql server process memory has been paged out ” that gets written to the SQL Server Error log. You can find the details about the various parameters that determine
Posted by psssql | 1 Comments
Monday, May 11, 2009 5:41 PM

How Do I Determine Which Dump Triggers Are Enabled

_____________________________________________ Subject: RE: dumptrigger question They don't survive service restart. SQL 2000 did not have dumptrigger enabled for all error messages and I think 1105 is an ex_callprint instead of ex_raise so it won't work
Posted by psssql | 1 Comments
Filed under: , ,
Thursday, May 07, 2009 3:08 PM

SSIS 2005 and the .NET Garbage Collector

I was troubleshooting an SSIS Out of Memory issue the other day which led us into how the .NET Garbage Collector (GC) works.  When debugging it, I found that we were using the Workstation GC with Concurrent GC On (this is the default for .NET applications). 
Posted by psssql | 1 Comments
Wednesday, May 06, 2009 5:25 PM

How to use FileStream feature in an ASP.NET Web Application that uses Forms or Anonymous authentication

We have a customer who uses Form based authentication in his ASP.NET application. But he also wants to use FileStream feature. Authentication becomes a challenge. In order for FileStream to work, sql connection needs to use ingetrated security (not SQL
Posted by psssql | 1 Comments
Filed under:
Friday, May 01, 2009 10:31 PM

SQL, Powershell, Windows, Oh My!

I was in the process of setting up a repro for another Blog I’m going to be posting and ran into an unexpected situation.  My VM was running Windows 2003 and I had installed SQL 2008.  I was then going to upgrade to Windows 2008 Server and came
Posted by psssql | 1 Comments
 
Page view tracker