Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » 2005   (RSS)
Wednesday, September 23, 2009 9:58 PM

Did your backup program/utility leave your SQL Server running in an squirrely scenario?

My colleges asked me if 'squirrely' is a technical term and for this post the answer is yes.  CSS is not going to deny support to customers but SQL Server was not tested in this scenario so you may have chased yourself up a tree, hence I use the
Posted by psssql | 0 Comments
Thursday, September 17, 2009 3:08 PM

How It Works: What are the RING_BUFFER_RESOURCE_MONITOR telling me?

The ring buffer records (which can be sent to XEvent) for Resource Monitor and Memory Broker are the key aspects to understanding RM.  The record is produced when a change is detected in state monitored by RM.    CREATE EVENT SESSION RingBufferInfo
Posted by psssql | 0 Comments
Friday, August 21, 2009 7:50 PM

SSMS Fails to restore with SQL 2000 instances and SSMS Versioning Explained….

I recently have been on vacation. When I returned I noticed an interesting issue that deserves some details and explanation in case you encounter the problem. As part of this explanation, I’ll give you some information about how the “version” of SQL Server
Posted by psssql | 0 Comments
Tuesday, August 18, 2009 5:30 PM

SQL Server Cumulative Update or Service Pack Fails With - CREATE DATABASE failed

Here is a situation where a cumulative update patch can fail if the default database path for the data and/or log either does not exist, or there is a permissions issue.  This example is based on a SQL Server 2005 Cumulative Update 4 for SP3. 
Posted by psssql | 0 Comments
Wednesday, June 24, 2009 4:44 PM

Installing .NET 3.5 Framework for SQL Server 2008 on a Windows 7 / Windows 2008 RC2 Builds

The SQL Server 2008 install requires the .NET 3.5 framework.   Changes in Windows 7 can prevent SQL Server 2008 from installing the .NET 3.5 framework pre-requisite.   Instead you may need to install the framework separately. In Windows
Posted by psssql | 4 Comments
Tuesday, June 16, 2009 6:18 PM

SQL Server on Windows 7 / Windows 2008 R2 with more than 64 CPUs

The release of the Windows 7/Windows 2008 R2 will support more than 64 CPUs. It is also documented that the SQL Server 10.5 (Kilimanjaro - http://news.cnet.com/8301-13860_3-10236936-56.html ) will extend the SQL Server Engine to support more than 64 CPUs.
Posted by psssql | 1 Comments
Tuesday, June 09, 2009 3:08 PM

SQL Server 2005 Setup Failure (Multi-Core, Tri-Core, …)

SQL Server 2005 has a startup check that fails on some of the newer CPU socket designs (triple core, tri core, 12 core, …) as outlined in the knowledge base article: http://support.microsoft.com/kb/954835 Continued testing shows that the NUMPROCS workaround
Posted by psssql | 0 Comments
Filed under: , ,
Thursday, June 04, 2009 10:20 PM

RDTSCTest CPU Speed Output Clarified

Starting with SQL Server 2005 SP3 and SQL Server 2008 the RDTSC counter is not used for timing in SQL Server but you may still have occasion to use RDTSCTest.   From: Robert Dorr Sent: Thursday, June 04, 2009 4:14 PM Subject: RE: SQL Troubleshooting
Posted by psssql | 0 Comments
Filed under: , , ,
Thursday, June 04, 2009 3:19 PM

SQL Server TempDB – Number of Files – The Raw Truth

I continue to answer questions about the number of TEMPDB files and trace flag –T1118.   It seems there are plenty of advice blogs, wikis, articles and other resources.   To help clarify this I am going to post my latest e-mail exchange.
Posted by psssql | 2 Comments
Filed under: , , ,
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: , , ,
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: , , ,
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
Friday, April 24, 2009 12:14 PM

SQL Server, Locked Pages, and Standard SKU…

I made an announcement today while speaking at Europe PASS 2009 that we will be providing a method for customers using standard SKU for SQL Server 2005 and 2008 to use the ‘Locked Pages in Memory’ privilege to allow the server to use the AWE APIs. This
Posted by psssql | 10 Comments
More Posts Next page »
 
Page view tracker