.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

TempDB High Value for mixed_extent_page_count

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
Hi all, I'm trying to get to the bottom of a size issue with a TempDB.  TempDB consists of two data files - an 8MB primary (no autogrowth), and a 9.5 GB secondary (set to grow no larger than 10 GB). The problem is that the available space, as reported by Perfmon ("Free Space in tempdb (KB)") and "unallocated_extent_page_count" from sys.dm_db_file_space_usage is 3383 MB.  This indicates that 6300 MB is being used inside TempDB. Examining sys.dm_db_file_space_usage reports the following figures for the secondary TempDB database (the first is neligible, being 8 MB): unallocated_extent_page_count: 433000 (3383 MB) version_store_reserved_page_count: 64 (0.5 MB) user_object_reserved_page_count: 64 (0.5 MB) internal_object_reserved_page_count: 320 (2.5 MB) mixed_extent_page_count: 812120 (6344 MB) So, obviously the space is being taken by mixed extents.  But what?  sys.dm_db_task_space_usage and sys.dm_db_session_space_usage do not show any space being used.  There are no objects with large number of pages in their indexes.  sp_spaceused reports 2 MB reserved (which makes sense, as it's derived from sys.dm_db_partition_stats). The only other clue I have is that the Version Store was continually growing, and filled TempDB, resulting in a Version Store shrink operation.   The version store size was up to 3891 MB, and the followin

View Complete Post

More Related Resource Links

ASP.NET Best Practices for High Performance Applications

This article lists the techniques that you can use to maximize the performance of your ASP.NET applications. It provides common issues, design guidelines, and coding tips to build optimal and robust solutions.

High-Performance .NET Application Development & Architecture

It has always been a goal of project architects to plan an effective strategy from the ground up in regards to an new application. All relevant factors are taken into consideration with respect to the application, from its design and layout to a functional website infrastructure. Pre-.NET strategies and design guidelines still effective now were developed with Microsoft's DNA (Distributed interNet Application) platform. This model successfully served the purpose of architecting N(any number of)-Tier (levels) applications. In its basic sense, as in most robust, distributed applications, you'll architect 3 main layers or Tiers: presentation, business rules and data access.

High Performance ASP.NET - Speeding Up ASP.NET Pages

have been writing a series of blog posts, which I have named High Performance ASP.NET Websites Made Easy! There is no rhyme or reason to the order of these posts and certainly can be read in any order:

Developing High Performance and Scalable ASP.NET Websites
Avoid Chatty Interfaces Between the Tiers in Your ASP.NET Web Application
ASP.NET Page Profiling - Page Tracing - High Performance and Scalable ASP.NET Websites Made Easy
Web Applications: N-Tier vs. N-Layer - Benefits and Trade-Offs
Query Analyzer - Sql Server Database Indexes and Execution Plans

10 Tips for Writing High-Performance Web Applications

Writing a Web application with ASP.NET is unbelievably easy. So easy, many developers don't take the time to structure their applications for great performance. In this article, I'm going to present 10 tips for writing high-performance Web apps. I'm not limiting my comments to ASP.NET applications because they are just one subset of Web applications. This article won't be the definitive guide for performance-tuning Web applications-an entire book could easily be devoted to that. Instead, think of this as a good place to start.

Cloud Computing: Patterns For High Availability, Scalability, And Computing Power With Windows Azure


Here we examine the typical cloud platform architecture and some common architectural patterns, along with their implementation on the Windows Azure offering from Microsoft.

Joshy Joseph

MSDN Magazine May 2009

Windows with C++: Exploring High-Performance Algorithms


See how you can gain efficiency in surprising ways by looking closely at your algorithms, the data they operate on, and the hardware you're designing for.

Kenny Kerr

MSDN Magazine October 2008

.NET Profiling: Write Profilers With Ease Using High-Level Wrapper Classes


Here Joachim H. Fröhlich and Reinhard Wolfinger show you how to get all the great functionality of the .NET Profiling API the easy way, with custom wrappers.

Joachim H. Fröhlich and Reinhard Wolfinger

MSDN Magazine April 2006

High Availability: Keep Your Code Running with the Reliability Features of the .NET Framework


Reliability requires the capacity to execute a sequence of operations in a deterministic way, even under exceptional conditions. This allows you to ensure that resources are not leaked and that you can maintain state consistency without relying on application domain unloading (or worse, process restarts) to fix any corrupted state. Unfortunately, in the.NET Framework, not all exceptions are deterministic and synchronous, which makes it difficult to write code that is always deterministic in its ability to execute a predetermined sequence of operations. In this article Stephen Toub will show you why, and explore features of the .NET Framework 2.0 that help you to mitigate these situations and write more reliable code.

Stephen Toub

MSDN Magazine October 2005

Winsock: Get Closer to the Wire with High-Performance Sockets in .NET


The Win32 Windows Sockets library (Winsock) provides mechanisms to improve the performance of programs that use sockets, and the Microsoft .NET Framework provides a layer over Winsock so that managed applications can communicate over sockets. To use all these layers to write a truly high-performance socket-based application requires a little background information, as Daryn Kiely explains here.

Daryn Kiely

MSDN Magazine August 2005

ASP.NET: 10 Tips for Writing High-Performance Web Applications


Writing a Web application with ASP.NET is unbelievably easy. So many developers don't take the time to structure their applications for great performance. In this article, the author presents 10 tips for writing high-performance Web apps. The discussion is not limited to ASP.NET applications because they are just one subset of Web applications.

Rob Howard

MSDN Magazine January 2005

Timers: Implement a Continuously Updating, High-Resolution Time Provider for Windows


The timestamps that you can obtain from Windows NT are limited to a maximum resolution of 10 or 15 milliseconds, depending on the underlying hardware. At times, such as when you need to timetag frequent events, it is desirable to achieve a higher resolution. For example, what if you want to be able to contact a thread or perform some other task at intervals more frequent than 10 milliseconds? Suggested ways of achieving better resolution include using performance counters in conjunction with the sytem time to calculate smaller time increments. But using performance counters is a technique that presents its own problems. This article shows one possible way of overcoming limitations inherent in this approach.

Johan Nilsson

MSDN Magazine March 2004

ATL Server and Visual Studio .NET: Developing High-Performance Web Applications Gets Easier


When developing high-performance applications for the Web, developers often must choose between performance and ease of development. With ATL Server, new with Visual Studio .NET, developers get the best of both worlds. ATL Server uses a tag replacement engine written in C++, provides a simple programming model, and promotes enhanced performance and easy debugging. This article presents an overview of the ATL Server architecture, then creates a basic ATL Server project. It then goes on to explain processing SRF files, HTTP streams, forms, cookies, and header files. Managing session state is also discussed, along with file uploads and performance monitoring.

Shaun McAravey and Ben Hickman

MSDN Magazine October 2000

Designing and Developing High-Performance SharePoint Server 2007 Publishing Sites

Learn about the Web Content Management features in SharePoint Server 2007 that enable organizations to deploy Internet-facing publishing sites, and considerations for developers and designers when designing and building high-performance publishing sites.

SQL Server RAID 1 , 1+0 and TempDB

Hi, I am tuning a disk sub system for our OLTP datebase server these days. This is DAS disks. I now came into a question. The server has 8 148GB SAS drives. To have fault tolerance, we want to have RAID mirroring, so RAID 1 or 10. That leaves us half of the whole capacity, which is 4 * 148GB. As this box is only used for database, we want to have partitions for OS, data file, log file and temp db. Now I there is a dilemma: I know for best practise, temp db should on its own physical disk. If I set up four partition(logical drives), one for OS, one for data files, one for logs and one for temp db, then I can only have RAID 1 on each of the disk array. But the advantage of this is temp db is only its own disk. Or the second choice I can have is to partition the disks into three array (logical drives), namely OS, data files and logs. In this case I can have RAID 1+0 (striping and mirroring) on data file partition and RAID 1 on OS  and log. Could you give me some idea, which one is better? Any disscussions are welcome. Thank you very much.

Workflow Service failing on high load

Hi, I am load testing my workflow service to ensure that it can sustain high loads for a high volume transaction application. I am using Visual Studio's Load Test to run on a simple unit test to call the workflow service. I have configured the bindings on my service as follows:  <bindings>      <netTcpBinding>        <binding portSharingEnabled="true" closeTimeout="00:10:00"                 openTimeout="00:10:00" receiveTimeout="00:10:00" sendTimeout="00:10:00"                 maxBufferPoolSize="20480000" maxBufferSize="20480000" maxConnections="10"                  maxReceivedMessageSize="20480000"  >                    <security mode="None" />        </binding>      </netTcpBinding>  &n

WF4 for High Volume Transaction Apps

Hi! I am in the middle of redesigning my application and I would like to consider WF4 as the center piece for my application logic. My application is an sms gateway service and it can reach up to millions of hits within a short period of time. I would like to know whether WF4 is suitable to be used for millions of hits type of application. Thank You :) Best Regards, Serena

Can someone give me a high-level overview of DD? What else does it do besides scaffolding?

Hello,Having spent the past couple of weeks looking into DD, I'm impressed with the ease and speed with which you can get a CRUD web site up and running.However, I've come across a few things in the last day or so that make me think I'm missing a major part of DD. I've seen hints of much, much more in there. For example, some of the posts on Stephen Naughton's blog mention all sorts of things that look really clever, but are a bit past my understanding of DD at the moment. This makes me feel there's a lot more in there that I have realised.So, can anyone give me an overview of the full picture of what DD offers? Is there more to it than just scaffolding?Thanks
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend