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.
I am developing an application for queries and reporting. The problem is that access to data is through an old database fox pro, via the network, the system still works for the company, the application is for queries and reports that will be available on the Local network.I wonder if I can increase performance if I copy the database locally before starting the day or in a specific time of day, to make access faster and if you need to update the data then you would copy it again.As I say, is only for reports that do not require that the information is at the last minute.
Some queries take longer to be executed.
What you will do? of course, Better would be a new systems jejej, but they won't.
We have a slow-performing query and, after some analysis, have narrowed the cause down to using parametrized queries in conjunction with LIKE and aggregate comparisons used in the WHERE clause. If we use a non-parametrized query (but keep the WHERE
clause the same) the query performs much faster and, in fact, executes a different plan. Using OPTIMIZE FOR UNKNOWN is not an option for us as we are using SQL Server 2005. Obviously, we'd like to use parametrized queries to prevent SQL injection
but the slow perf is unacceptable. We need the LIKE to support wildcard scenarios. If we need to we'll use dynamic SQL (scrubbed as much as we can) in lieu of parametrized queries. We're wondering, however, is there another option that would
give us the perf without sacrificing safety? I can provide a sample database, query, plans, etc. if necessary...I'm assuming SQL Server generates a less efficient plan with the parametrized query as it can't make any assumptions about the parameter values...
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
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?
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.
Hello i need several queries.
1- auto index suggestion query. dont tell me sql server profiler since it always fails because my sql server processes about 10000 query per second maybe more
2- performance degreading index finder query
3- duplicate index finder query
4- fragmantation rebuild query