1)ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ What meant by Performance Tuning, how can we do the performance tuning onÃÂ stored procedures and tell some steps to do the performance tuning?
View Complete Post
Understanding performance bottlenecks in multithreaded apps used to require significant instrumentation and analysis by expert developers. The Concurrency Visualizer in Visual Studio 2010 significantly reduces the burden of parallel performance analysis.
MSDN Magazine March 2010
Event Tracing for Windows (ETW) provides general-purpose, high-speed tracing of events raised by both user-mode applications and kernel-mode device drivers. Learn how ETW can improve your development and debugging work.
Dr. Insung Park and Ricky Buch
MSDN Magazine April 2007
Because the common language runtime (CLR) is a black box, it's pretty hard to divine what's going on when you want to track down performance problems. Microsoft will be delivering a brand new profiler, the Enterprise Performance Tool (EPT), as part of Visual Studio 2005 Team Developer Edition that's ideal for use on a production system because it offers some very lightweight means of collecting performance data. Here John Robbins takes you on a tour.
MSDN Magazine December 2004
I have two subqueries which build a string (varchar(200)), first subquery creates 200000 records and second 50000 records, how can I write a select statement to get records from subquery first with string existing in second subquery records.
Will sorting both the sub query results be helpful? Kindly advice for best performing select statement.
There are 20 tables with the same schema. And a view
create view Everything
select 1 as area, pk_col1, pk_col2, col1, col2, ... from T1
select 2 as area, pk_col1, pk_col2, col1, col2, ... from T2
select 3 as area, pk_col1, pk_col2, col1, col2, ... from T3
select 4 as area, pk_col1, pk_col2, col1, col2, ... from T4
select 5 as area, pk_col1, pk_col2, col1, col2, ... from T5
However, the foll
Caught up with few Issues, Advice is highly appreciated:
We are trying to improve the performance of our query by adding some indexes amd eliminating some unwanted stuff. When I run the old and the new query in o together and check the execution plan, I could see Cost relative to batch, the old query
is higher then the new query,I think that is a good sign but what I want to know is how true it is. The reason for asking is I have read it is only estimate and not neccessarily be true.
And also , While testing I would like to clear the server cache, I am using dbcc dropcleanbuffers command for that, Does that clear the server cache or is there any other Command?
Is it good to have Clustered index on identity field, it also happens to be the PK of the table.Are there any disadvantages in making identity field as PK and have clustered index on it?
While doing Transactional Replication, if we happen to add a new table at publisher, does that not replicated on to the subscriber unless a snapshot is generated again, if not, is there anyway we can generate the snapshot only for that table and replicate
it,because I do not want to generate the snapshot for the entire DB.