Are there specific tools to perform the following job or there is a suite of tools that help me do the following: How can I check page load times? How can I track down a page that hogs memory? How can I track a page that consumes a lot of CPU cycles? I just want to glean from the experience of this forum and come across a holistic v...
SQL Server 2005: I have a SiteVisit row which contains information about a users visit, for instance HttpRefer, whether or not they placed an order, browser, etc. Currently for reporting I am joining this table with SiteEvent which contains information about each 'section' visited. This then produces a view which shows statistics about...
What is the single most important performance tuning area for a WCF Web service? ASP.net Thread settings? WCF throttling? ...
I have this SQL query: SELECT * FROM IMAGES WHERE IMAGENAME in ('IMG1', 'IMG2', 'IMG3', 'IMG4', 'IMG5', 'IMG6') ORDER BY CASE IMAGENAME WHEN 'IMG1' THEN 1 WHEN 'IMG2' THEN 2 WHEN 'IMG3' THEN 3 WHEN 'IMG4' THEN 4 WHEN 'IMG5' THEN 5 WHEN 'IMG6' THEN 6 ELSE 7 END I cannot guarantee that the list of IMAGENAMEs will be in alp...
I have two tables: a source table and a target table. The target table will have a subset of the columns of the source table. I need to update a single column in the target table by joining with the source table based on another column. The update statement is as follows: UPDATE target_table tt SET special_id = ( SELECT source_specia...
Which tricks do you know to make the experience with Eclipse faster? For instance: I disable the all the plugins I don't need (Mylyn, Subclipse, ). Instead of using a plugin for Mercurial I configure TortoiseHG as an external tool. ...
Is there any good article, tutorial or similar references on interpreting the Execution Plan of a query in SQL Server 2005? ...
I'm running an upgrade script against a database hosted in Microsoft SQL Server. It's taking a while. Some of the queries are not worth optimising any further, for various reasons. I'm the only person using this database: Is there a way that I can tell SQL Server to not bother with transactions/locking? For instance, on a DELETE ... WH...
Hi I am having some performance problems with my Delphi 2006 app. Can you Suggest any profiling tools that will help me find the bottle neck i.e. A tool like turbo Profiler ...
I have a webpage that is taking way too long and need to optimize it. Because uninformed optimizing is the devil, I need to know what exactly is holding me down. A quick glance showed me that it is probably an sql2linq query that is most likely causing the trouble. What are techniques of pinning the performance problem in this case? Are...
Do class, method and variable names get included in the MSIL after compiling a Windows App project into an EXE? For obfuscation - less names, harder to reverse engineer. And for performance - shorter names, faster access. e.g. So if methods ARE called via name: Keep names short, better performance for named-lookup. Keep names crypt...
I'm looking for a kind of array data-type that can easily have items added, without a performance hit. System.Array - Redim Preserve copies entire RAM from old to new, as slow as amount of existing elements System.Collections.ArrayList - good enough? System.Collections.IList - good enough? ...
I have been trying to get my head around to understanding performance and scalability and would like to know what developers/sysadmins are doing to juice their systems. To standardize the answers, it would help if you could take your best shot at responding to any of the following: Profile - Magazine publication on Joomla; Jobs board o...
Hello, I have an SQL Server 2000 query which performs an clustered index scan and displays a very high number of rows. For a table where I have 260.000 records, the actual number of rows displayed in the plan execution is ... 34.000.000. Does this makes sense? What am I misunderstanding? Thanks. ...
Say I have the following code snippet in c# static const bool DO_PERFORMANCE_CODE = false; if (DO_PERFORMANCE_CODE) { // performance monitoring code goes here } Will that code get removed by the compiler? This is the functionality I'd like. Basically I want to mimic the conditional compilation stuff in C#, but I want more configur...
I'm working on performance tuning my SQL Server 2008 database and am using the output from various DMVs to identify missing indexes, indexes that aren't being used, etc. I am mainly using these 3 scripts (from SQLServerCentral.com) that rely on DMV data that SQL Server provides: The Ultimate Missing Index Finder The Ultimate Duplicate...
So I have this query that is relatively fast at ~0.5 seconds but when I add an ORDER BY clause it jumps up to nearly 30 seconds. Original query: (returns in ~0.5 seconds) SELECT table1.*,table2.* FROM table1 LEFT OUTER JOIN table2 ON table1.column2=table2.column3 WHERE table1.column1='value' LIMIT 4 Query with ORDER BY: (returns in ~...
If I use "top" I can see what CPU is busy and what process is using all of my CPU. If I use "iostat -x" I can see what drive is busy. But how do I see what process is using all of the drive's throughput? ...
I've just started my first development job for a reasonably sized company that has to manage a lot of data. An average database is 6gb (from what I've seen so far). One of the jobs is reporting. How it's done currently is - Data is replicated and transferred onto a data warehouse. From there, all the data required for a particular repo...
Virtual memory was introduced to help run more programs with limited memory. But in todays environment of inexpensive RAM, is it still relevant? Since there will be no disk access if it is disabled and all the programs will be memory resident, will it not improve the performance and program response times? Is there any essential requi...