Welcome to MSDN Blogs Sign in | Join | Help

December 2008 - Posts

Wednesday, December 31, 2008 3:30 PM

SQL 2005 JDBC Driver and Database Mirroring

We ran into some interesting situations with the SQL 2005 JDBC Driver (v1.2) and it's use with failover partners. Take the following connection string: jdbc:sqlserver://myserver1;databaseName=AdventureWorks;failoverPartner=myserver2; In this connection
Posted by psssql | 2 Comments
Monday, December 29, 2008 4:41 PM

Failure to load Report Manager due to truncated UserAgent string

We came across an issue when trying to load Report Manager.  We would get the following exception: System.ArgumentException: Version string portion was too short or too long. at System.Version..ctor(String version) at System.Web.Configuration.HttpCapabilitiesBase.GetClrVersions()
Posted by psssql | 1 Comments
Friday, December 19, 2008 7:45 PM

Using SQLIOSim to Diagnose SQL Server Reported Checksum (Error 824/823) Failures

This is an extension to by previous post about SQLIOSim data integrity testing. http://blogs.msdn.com/psssql/archive/2008/03/05/how-it-works-sqliosim-checksums.aspx SQLIOSim (.exe/.com) is the predecessor to SQLIOStress.   SQLIOSim is SQL Server
Posted by psssql | 1 Comments
Wednesday, December 17, 2008 8:01 PM

SQL Server (2005 and 2008) Trace Flag 1118 (-T1118) Usage

Trace flag 1118 forces uniform extent allocations instead of mixed page allocations.   The trace flag is commonly used to assist in TEMPDB scalability by avoiding SGAM and other allocation contention points. SQL Server 2008 optimized mixed extent
Posted by psssql | 1 Comments
Tuesday, December 16, 2008 11:47 PM

How It Works: SQL Server No Longer Uses RDTSC For Timings in SQL 2008 and SQL 2005 Service Pack 3 (SP3)

Many of you have encountered the RDTSC timing variances that I outlined in an earlier blog post:   http://blogs.msdn.com/psssql/archive/2006/11/27/sql-server-2005-sp2-will-introduce-new-messages-to-the-error-log-related-to-timing-activities.aspx
Posted by psssql | 3 Comments
Friday, December 12, 2008 8:46 PM

How It Works: SQL Trace and MARS Connections

MSDN, TechNet, Books Online and other sources outline what Multiple Active Result Sets (MARS) is, how to use it and transaction scopes.   Working on an issue this week I found I needed to understand what the trace looked like.  In doing
Posted by psssql | 1 Comments
Filed under: ,
Friday, December 12, 2008 8:22 PM

INF: RML Utilities: Turning on Trace Flags

Summary When using the RML utilities the logged message or documentation can indicate that use of a trace flag is necessary to change behavior. More Information The RML Utilities use command line parameter ( -T ) as a trace flag to alter the utilities
Posted by psssql | 0 Comments
Filed under: ,
Tuesday, December 02, 2008 5:02 PM

How It Works: What is behind the SQLCLR wait category in SQL Server 2008 Activity Monitor

I was asked a question as the CSS First Aid Station at SQL PASS 2008 where the Activity Monitor kept showing the SQLCLR wait category as the top waiter, even when no other activity was going on.  After some digging I found that this is a bug and
Posted by psssql | 1 Comments
 
Page view tracker