.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

SQL Server - Performance Collection

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
Hello: i have question in regards to collection sets when done in file format CSV for more than 4-5 days. usally when done for more than 3-4 days & Perfmon CSV file open in Excel is very misleading when viewed in graphical format. for e.g. when i see in graph format for processor time done for 4-5 days it shows like 90% usage but when doing AVERAGE for same counter show like 10-15%. is there better way to display same info in a correct graphical format. I am not interested in 3rd party tool & i know they can provide more accurate information. i am looking for defaults that comes with Microsoft. Any help is appreciated. Thanks  

View Complete Post

More Related Resource Links

SQL Server Performance

Improving .NET Application Performance and Scalability
SQL: Scale Up vs. Scale Out
Stored Procedures
Execution Plans
Deployment Considerations

SQL Server: Uncover Hidden Data to Optimize Application Performance


SQL Server 2005 gathers a lot of useful data that you can use to identify areas where database performance can be improved. Here's what you need to improve performance.

Ian Stirk

MSDN Magazine January 2008

IIS 6.0: New Features Improve Your Web Server's Performance, Reliability, and Scalability


As the Web evolves, so does the role that Internet servers play. The Internet has seen the growth of e-commerce, B2B business, collaboration, streaming and other new media, and these new applications require new features to meet increasingly complex needs. Microsoft Internet Information Services (IIS) has many of the features today's mature Web sites need. This article outlines the features in the upcoming version 6.0 and discusses how they promote better scalability, reliability, and performance. Features such as Remote administration, caching, and metabase improvements, as well as custom isolation and security enhancements, make IIS 6.0 the Web server of the future.

George Shepherd

MSDN Magazine March 2002

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 2005 Performance Dashboard Reports user context

HI, We are planning on installing the Dashboard reports. But we'd like to know if the Dashboard is run under admin user or the login user who runs the Dashboard reports? Thanks! Kong

Error 2908 while installing sql server 2005 management objects collection on Win 7

I have SQL Server native client 2005 installed on Win 7 64-bit machine. While installing SQL Server XMO 2005 it gives error 2908 and aborts installation. Any suggestion on the error?

MDX query using linked server - performance question

Hi, I'm having a strange performance behavior. When I’m running a mdx query on management studio, it runs for 10 minutes (its mainly calc members on a large cube) When I run the same query via linked server and openquery, it runs for 20 minutes. Is the SQL from some reason does a parsing or running the query twice? The server is sql2008 UP1 on 64bit. and the "allow in process" is checked. its the default in sql2008 Thanks in advance, Yoav  

custom server control with custom child collection,get the collection?

Hi!I want to create a custom server control, that then will have a custom child collection.The thing is that I also want to be able to modify the custom childs from the custom server control classFor example I have a row of cards, and the class is called CardRow, a CardRow is simply a class full of the class card in this case, se the class "Card" down below:using System; using System.Collections.Generic; using System.ComponentModel; using System.Linq; using System.Text; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Collections.Generic; namespace MemoryLib { [ToolboxData("<{0}:CardRow runat=server></{0}:CardRow>")] public class CardRow : WebControl { public List<Card> _Card; [PersistenceMode(PersistenceMode.InnerProperty)] public List<Card> Card { get { return _Card; } set { _Card = value; } } public CardRow() { } protected override void CreateChildControls() { } protected override void Render(HtmlTextWriter writer) { } } } using System; using System.Collections.Generic; using System.ComponentModel; using System.Linq; using System.Text; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace MemoryLib

PS2007/MSSQL2008: Cannot install Microsoft SQL Server 2005 Management Objects Collection (sqlserver2

Hi folks, about 1,5 months ago I have set up a - 1 server - development environment for PS2007. I had installed all components on one Windows 2008 box. Everything worked fine, now I receive an error. •MOSS 2007 •SQL 2008 SP1 •MOPS 2007 SP2 I have done the additional installation for the cube building part according to this page http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx Microsoft SQL Server Native Client (sqlncli.msi) Microsoft SQL Server 2005 Management Objects Collection (sqlserver2005_xmo.msi) Microsoft SQL Server 2005 Backwards Compatibility Components (SQLServer2005_BC.msi) Everything worked fine. Cubes were able to be built.. everything was good. In order to have Reports built I added SSRS 2008 Reporting Services Addin for MOSS (rsSharePoint_x64) Business Intelligence Development Studio (=Visual Studio for MSSQL) No CUs have been added to this box. NOW, Cube creation fails with the error: ULS LOG: [CBS] ProjectServerOlapCubeGenerator status: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <IPADDRESS>. Error: ActiveX component can't create object 08efbc13-299a-4abe-9021-c46887ca6915 Eventlog says: SSP Name: SharedServices1 PSError: CBSASConnectionFailure (17003) Cube build failed to connect to the Analysis Services server. Verify the data source connection i

Slow performance when searching in "any part of field" of a SQL Server database using a Microsoft Ac

We have just migrated our back end database from Access to MS SQL Server 2008 R2. We have noticed better performance on our searches - unless we select to search in "any part of field" in Access (with Access' built-in search function - we use a mix of Access 2003 and 2007). This takes nearly 20 seconds to find the result, whereas before the migration it was taking 5-7 seconds (compared to instant results we now experience when searching for whole fields). The main fields we search are not large - usually just two words. Obviously it is better to search for a whole or start of a field, but this is not always possible. The contractor that assisted us in this project has told us that this "is just the way SQL works with Access". Is this really true? I find it hard to believe two MS products would have such a big issue between them. I presumed using SQL with an Access front end would be a common setup, which is why I thought this must be a problem with our setup. Is there any way to fix this speed issue?

Performance Monitor Counters To View How "Busy" A SQL Server Is

What are some good performance monitor counters to look at, when trying to figure out how "busy" our SQL 2008 server is? We were told to look at: SQLServer: SQL Statistics: Batch Requests/Sec and SQLServer: Databases: Transaction/Sec . Any other critical ones? Is there a counter to get the number of  selects, updates, and deletes independently per second? Thanks.

How to calculate a SQL Server performance of a query based upon table schema, table size, and availa

Hi What is the best way to calculate (without actual access to a SQL Server) the processing speed of a query (self-inner-join) based upon table schema, table size, and hardware (CPU, RAM, Drives)? ThanksThanks Jeff in Seattle

SQL Server 2008 performance: Decision to spend budget to upgrade to enterprise edition

Hi, Currently, we use SQL Server 2008 standard edition. We are planning to improve the performance of our application. The application is built by 3<sup>rd</sup> party and we can’t change/modify database objects and they seem to be designed fine. The options are spending our budget to upgrade to sql server hardware, or upgrade to SQL Server Enterprise edition. I am a bit confused over the benefits of SQL Server Enterprise edition. The following chart suggests that SQL EE includes “Parallel Index Operations” and “Enhanced Read-ahead and Scan”: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx  How significant are “Parallel Index Operations” and “Enhanced Read-ahead and Scan”? Considering the fact that new hardware is cheaper than sql enterprise license, Should I spend budget to upgrade enterprise edition instead of buying as server with faster CPU and RAM? Thank you, Max

Can anyone explain how SQL Server performance scales with CPUs/Cores, memory, disk drives, etc?

I have experienced the situation where our application running on an expensive system with two 4 core CPUs ran slower than on a cheap machine with one dual core CPU. Both machines had similar memory capacity. In each case, the same query was being run by only one user. It would be nice to find a way to increase performance, but if adding cores doesn't help, what can a poor developer do? Customers get annoyed when they spend a truckload of money on a new server and nothing changes... Another potential problem is when customers have an expensive SAN system Sometimes the performance is much slower then on a system with conventional storage. Can anyone explain the relationship between SQL Server perfomance and hardware ?

SQL server poor performance - Urgent help

I have a windows 2003 Server Processor 880, 2.40GHz and 8Gb RamIts 64 bit  - SQL 2005It is on a SAN with Raid 5 on disksThere is one 50gb database mainly being used.The Server CPU is constantly up and down and Maxing out every few mins.There are runnable processes running and numerous suspended.Running Sp_who2 doesn't give much info and often shows no blocking or anything noticeable.Users are getting timeouts and not able to use the system.I looked at the memory allocation it was ;The Results were;name minimum maximum config_value run_valuemax server memory (MB) 16 2147483647 2147483647 2147483647name minimum maximum config_value run_valuemin server memory (MB) 0 2147483647 0 0 I have updated this and amended BOTH to be 6500, being max and min but not certain this is right.I can see in task manager in the performance window that it's using at 8gb, but if you look at the processes tab sqlserver.exe is only using 149 858k. I do not understand why sqlserver.exe is NOT using the available memory ? For example I ran DBCC checkdb and the only user on the server as it's out of hours and this task alone maxes out the CPU.I am also about to rebuild indexes and complete some other maintenance tasks.I'm very puzzled that simple tasks are maxing out the CPU but no memory is being used. My company is unable to complete ANY work…..this is urgent please help.Thanks

Performance perspective of Lookup function in SQL Server 2008 R2

Hi, Recently I had presented a session on SSRS 2008 R2 enhancements. As part of that I explained about LOOKUP function and its way of working. There was a question while presenting this feature. From performance perspective, what are the advantages of LOOKUP function over conventional implementation of JOINING the lookup tables in stored procedure itself. I tried explaining that, it enables to make best utilization of resources in scaleout environment because the logic of JOIN evaluation has been shifted to Report Server than a database server. Some how the participants were not convinced. I would request experts to comment on this and help me in understanding whether my evaluation is correct or is there anything I am missing over here during my explanation. Please help.Phani Note: Please mark the post as answered if it answers your question.
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