Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Engine   (RSS)
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
Tuesday, September 22, 2009 8:49 PM

If you use linked server queries, you need to read this….

If you use the linked server feature with SQL Server 2005 and 2008, please read through this carefully. We have discovered several problems that can result in memory leak(s). The conditions are a bit complicated so let me try to describe the problems,
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
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, July 08, 2009 5:03 PM

Q&A on Latches in the SQL Server Engine….

I recently received a request to shed some light on a few advanced questions about latches and SQL Server. These were good questions so I thought the information might be useful to share with the community. I’ll provide this information in the form of
Posted by psssql | 1 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: , ,
Friday, June 05, 2009 3:48 PM

SQL Server and Large Pages Explained….

I gave a presentation on “debugging memory” at the recent Europe PASS Summit in April. In the talk, I mentioned that Large Pages would be used by SQL Server if you used trace flag 834. At the conference, Christian Bolton, a well-known MVP from the UK,
Posted by psssql | 3 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: , , ,
Tuesday, June 02, 2009 6:53 PM

SQL Server, Lock Manager, and “relaxed” FIFO….

An interesting question came in from a customer a few weeks ago. Did SQL Server change its traditional FIFO method for granting locks in SQL Server 2005 and 2008? Although there is no official documentation (not yet, I’ve put in a request to get this
Posted by psssql | 1 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: , , ,
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: ,
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: , , ,
More Posts Next page »
 
Page view tracker