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

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

Will Profiler causes system Performance.....some how urgent

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server

Hi all

I have a Production server with SQL Server 2000 in Production and I run the Profiler in other mechine to trace the queris and timings.

all of a sudden  application all down and Unable to connect the servers,I verified in Server   I found a transactional log job got failed as well.

I want know If I run the Profiler...will it effect perfromance of the Database Instance.....

I want search for clue..which is best place to check...


Thanks In Advance



View Complete Post

More Related Resource Links

Performance Tests: Precise Run Time Measurements with System.Diagnostics.Stopwatch

Everybody who does performance optimization stumbles sooner or later over the Stopwatch class in the System.Diagnostics namespace. And everybody has noticed that the measurements of the same function on the same computer can differ 25% -30% in run time. This article shows how single threaded test programs must be designed to get an accuracy of 0.1% - 0.2% out of the Stopwatch class. With this accuracy, algorithms can be tested and compared.

Performance: Find Application Bottlenecks with Visual Studio Profiler


We will introduce you to the Visual Studio Profiler by walking through a sample performance investigation, pinpointing code inefficiencies in some sample applications.

Hari Pulapaka and Boris Vidolov

MSDN Magazine March 2008

Team System - VS2008 -- Performance testing statistics


Dear all,


I am new to using performance testing in team system VS2008.

Could you tell me that What is the steps needed in VS2008 to create performance testing if I have the Web Application Source Code??

So that I can know where or which function need the most time. 

Very Slow Performance on 64 bit SQL System

Hello, we have a Windows Server 2008 64 bit and a SQL Server 2008 64 bit. The server work and the speed with a quad CPU and 8 GB RAM is nice. But, we use a SQL script with xml (we make a XML paket for replication) is the speed very slow. The script need 40 - 60 min to finish. But the same Database and the same script on a Server 2008 32 bit and SQL Server 2008 32 bit on the same hardware need 22 seconds. We have all updates installed. Have anywere a Idea? Thank

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

System.Diagnostics not working in IIS 6: Urgent

Hi All, I have developed a ASP.NET C# web page which connects to remote conmputer command prompt using PSEXEC.exe and executes some command where the output of the command will get copied to the page. It works fine in the VS 2005 IDE. If the page is accessed via IIS from IE, the task PSEXEC.EXE appears in task manager of the server with the system account privilege after the method is triggered but nothing happens. Please find my present settings in IIS and others: 1. APP Pool Identity to Local System (Predefined) and also to a configurable admin account. 2. <processModel userName="SYSTEM" password="AutoGenerate" /> in Machine.Config file Also I've tried impersonasation in web.config file to an admin account. I am not able to sort this problem, please help. I've tried a lot spending more time. Code Is:Process p = new Process(); string result = ""; p.StartInfo.UseShellExecute = false; p.StartInfo.CreateNoWindow = true; p.StartInfo.RedirectStandardInput = true; p.StartInfo.RedirectStandardOutput = true; p.StartInfo.FileName = @"C:\psexec.exe"; p.StartInfo.Arguments = @"\\nawrkxp613 -u domain\usename -p Password1 cmd.exe /c ipconfig"; p.Start(); StreamReader stdOut = p.StandardOutput; p.WaitForExit(); result = stdOut.R

performance test: Sql profiler recorded 8 seconds but only far less than 1 seconds executed in Manag

hi, all. I used sql profiler to record the long running sql while doing performance test. The performance test simulated 100 curcurrent users. When the test finished, I catched  some long running sql(some are select sql and some are update sql) in the sql profiler and executed them in the Management Studio, all of them finished execution in less than 1 second. I am curious about this. I  know under 100 curcurrent users operation, both Operating System and Sql Server have less resource to execute a given sql, so I thought they would finish execution in about 2 or 3 seconds rather than 8 seconds. I did the same performance test again and during the test, i executed those sql in the management studio. I become even more curious. Thoes sql still executed in less than 1 second. Why? I am new to performance test. Please help me. Thank you.

Sudden Error: Could not load type System.ServiceModel.Activation.HttpModule - Urgent Help Please


I have a windows 7 machine with IIS 7. I was hosting WCF services on IIS normally and i had a couple of services running.
Suddenly (i honestly did not do any configuration changes on my machine) all these services stopped working. When i try to browse the .svc file i get the following error:

"Could not load type 'System.ServiceModel.Activation.HttpModule' from assembly 'System.ServiceModel, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089'"

Just in case this information is helpful, all these services are running on the basicHttpBinding.

Please help!

SQL Profiler & Trace flag vs Performance


Hi all,

I just wonder how much the profiler will affect the live server's performance if I capture the following event for deadlock graph.
Locks -> Deadlock Graph

Also, if I onlyopen the trace, i.e. open the 1204 and 1022 trace flag, capture deadlock info in SQL Errorlog rather than capture the deadlock graph in Profiler, will it also affect the performance, and how much it will affect?

----> Kinect

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.

Top .NET Performance Problems and how to avoid them

Every time I work with one of our .NET customers to help them with managing their application performance I come across the same problems as seen with other clients before: lots of ADO.NET queries, many hidden exceptions in core or 3rd party .NET libraries, slow 3rd party components, inefficient custom code

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.

How to improve the performance of ASP.NET MVC web applications

It is an in depth analysis of a Digg-like site and how it went from serving (on a test machine) 6 req/sec to 390 req/sec.

The biggest gain, 74 req/sec to 390 req/sec happened when he introduced data caching and another 25 req/sec where gained when he introduced the compilation of LINQ queries.

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

Improving Application Performance in .Net

Application performance has always been a concern for Web Application developers. This article contains guidelines and tips for maximizing application performance in ASP.NET.

Tips to Improve Your ASP.NET Web site performance

ASP.NET has been developed with lots of features which makes developer life easy. Start from ViewState, PostBack, Server Controls , User Controls and etc. All of them can make your web development experience fun and easy, but improper use of them can cause your site performance slowdown. Most of the controls generate overhead to the client and server. Therefore in this article, I I will list out about things you can do and don't to improve your ASP.NET website performance.

System Development Life Cycle

The Systems Development Life Cycle (SDLC) is a conceptual model used in project management that describes the stages involved in an information system development project from an initial feasibility study through maintenance of the completed application. Various SDLC methodologies have been developed to guide the processes involved including the waterfall model (the original SDLC method), rapid application development (RAD), joint application development (JAD), the fountain model and the spiral model. Mostly, several models are combined into some sort of hybrid methodology
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