Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » 2008   (RSS)
Friday, November 13, 2009 5:02 PM

How It Works: How many databases can be backed up simultaneously?

Previously I have posted details on backup/restore designs and how to tell what backup/restore is doing. http://blogs.msdn.com/psssql/archive/2009/03/03/how-it-works-sql-server-vdi-vss-backup-resources.aspx http://blogs.msdn.com/psssql/archive/2008/01/28/how-it-works-sql-server-backup-buffer-exchange-a-vdi-focus.aspx
Posted by psssql | 0 Comments
Filed under: , , ,
Monday, October 26, 2009 5:35 PM

Reduce locking and other needs when updating data - Better Performance

The following pattern typically stems from an old practice used in SQL 4.x and 6.x days, before IDENTITY was introduced. begin tran declare @iVal int select @iVal = iVal from CounterTable (HOLDLOCK) where CounterName = 'CaseNumber' update CounterTable
Posted by psssql | 0 Comments
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 | 1 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, July 15, 2009 5:46 PM

How To Test Drive SQL Server Clustering For Free

I imagine that many of you are like me when it comes to purchasing software.   I want to take a test drive (evaluate) it before I buy it to make sure it really meets my needs.   You don't make a automobile purchase by just reading
Posted by psssql | 0 Comments
Filed under: , , ,
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
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: , , ,
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, March 31, 2009 8:00 PM

SQL 2005: SQL Server Configuration Manager Error: Connection to target machine could not be made in a timely fasion.

There is a bug with the message spelling (fasion instead of fashion) but that is not the focus of this post. When launching the SQL Server Configuration Manager you may receive this message if the WMI connections and queries do not complete within 30
Posted by psssql | 1 Comments
Filed under: , , ,
Monday, March 30, 2009 12:38 AM

SQLDumper unable to generate mdmp files in SQL Server 2008 Failover clusters

SQLDumper utility is used by various components of the product to generate and save diagnostic information in the form of mini-dump and other log files. You will normally find the output files [with extension .mdmp, .txt and .log] created by sqldumper.exe
Posted by psssql | 1 Comments
More Posts Next page »
 
Page view tracker