.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

partitioned view performance tuning question

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

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
union all 
select 2 as area, pk_col1, pk_col2, col1, col2, ... from T2
union all 
select 3 as area, pk_col1, pk_col2, col1, col2, ... from T3
union all 
select 4 as area, pk_col1, pk_col2, col1, col2, ... from T4
union all 
select 5 as area, pk_col1, pk_col2, col1, col2, ... from T5

However, the foll

View Complete Post

More Related Resource Links

Performance tuning tips for database developers

Performance tuning is not easy and there aren't any silver bullets, but you can go a surprisingly long way with a few basic guidelines.

In theory, performance tuning is done by a DBA. But in practice, the DBA is not going to have time to scrutinize every change made to a stored procedure. Learning to do basic tuning might save you from reworking code late in the game.

Below is my list of the top 15 things I believe developers should do as a matter of course to tune performance when coding. These are the low hanging fruit of SQL Server performance - they are easy to do and often have a substantial impact. Doing these won't guarantee lightening fast performance, but it won't be slow either.

Performance Tuning on DirectShow Camera Application

Windows CE 6.0 supports DirectShow® components to develop a rich camera application. A minimum requirement of the camera application is to show preview, capturing the still images which is stored as a compressed file (JPG) format, capturing/multiplexing the video with or without audio i.e. stored as a compressed file (WMV) format.

Windows CE 6.0 provides sample applications for showing preview, capturing still and video using DirectShow® components. However these sample applications doesn't cover all the aspects to develop a commercial application. A commercial camera application at least satisfies the following performance criteria.

Thread Diagnostics: Performance Tuning with The Concurrency Visualizer in Visual Studio 2010


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.

Hazim Shafi

MSDN Magazine March 2010

Event Tracing: Improve Debugging And Performance Tuning With ETW


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

.NET Code Tuning: Make Your Apps Fly with the New Enterprise Performance Tool


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.

John Robbins

MSDN Magazine December 2004

Can any one give me guide line in performance tuning of sql queries

What are the steps that any one should take for performance tuning in the case of sql-queries ?

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  

General Controller to View logic question

Hello, I am currently learning the MVC2 Framework and I have a brief question in terms of my logic and if their are any flaws in it. I created a basic example in a couple of minutes that demonstrates the way I think about it. public ViewResult Index() { return View(); } public ViewResult Cookies() { return View(new Cookie()); } public ViewResult CookiesInput(Cookie cookie) { return View(cookie); }<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server"> <h2>I really like cookies</h2> Would you like a cookie? <% using (Html.BeginForm("Cookies", "Example")) { %> <p><input type="submit" value="Yes" /></p> <% } %> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server"> <h2>Cookies</h2> <% using (Html.BeginForm("CookiesInput", "Example")) { %> <%= Html.EditorForModel() %> <p><input type="submit" value="Gimme" /></p> <% } %> </asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="MainConten

Noob Question - Using Linq in View

I just inherited an MVC2 application. So far my only experience with MVC is reading the Nerd Dinner sample chapter and downloading the nerd dinner app. I do plan to dive much deeper but i need a quick answer because i have to hit the ground running. So basically in the main Index view the view model is being passed as an IQueryable. Then he is doing some queries on the view model to loop through the data. See example below:<% if (Model.Where(w => w.State == workflowStep.Key).Count() > 0) { %>To me, even though minor, this is business logic and shouldn't be in the view. Shouldn't any type of logic like this be sorted out before you get to the view? Or is this common practice in MVC?Basically i want to know if I should spend time refactoring this thing or just go with the flow.  Thanks.

wcf performance tuning questions

We have an IIS 7.5 WAS hosted (net.tcp) internal WCF Service.  It is running on a Win2008 X64 R2 server with 8 cores (16 with hyperthreading) and 16gb RAM. The App Pool is set to 16 max worker processes.  We are trying to tune the client / service so that we can run as many worker processes as possible and keep the server as close to 100% CPU utilization as possible.   The client is coded for for 17 concurrent threads / WCF service requests (using .NET 4.0 TPL library).   However, I believe there is some bottleneck going on as the server CPU's never get above 40% utilization and the number of worker processes stays fairly low.  What is the best way to determine where the bottleneck is?  How do you determine if the bottle neck is client side or server side?   What perf counters should I be looking at client side?  What perf counters should I be looking at server side?  Is there a more efficient binding than Net.Tcp?   thanks

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.

Easy Calendar View Question - I hope

I have a Calendar in Sharepoint Foundation 2010. The only thing I want to do but can't is to have the Event Description text shown along with the Event title. Is it possible? Some event last several hours so there is plenty of space to show the text. TIA

Performance Tuning

Hi all,In my application , I am using many number of farpoint spread control. So the size of the page will be large.So the performance was very low. I have improved that by using update panels and some clientside scripts.while i am going through some articles on net, i found some suggestions as1. To use string.Empty  instead of ""2. To use StringBuilder instead of string.so i tried like ,        string str = string.Empty;        for (int i = 1; i <= 100000; i++)        {            str += string.Empty;        }now i am getting End Raise PostBackEvent 0.00284593221345047 0.001111 when i use,StringBuilder sb = new StringBuilder(string.Empty);        for (int i = 1; i <= 100000; i++)        {            sb.Append(string.Empty);        }the trace was End Raise PostBackEvent 0.00284593221345047 0.002418 .can you please tell me the difference.Also please suggest me some techniques to improve the performance.Thanks

Another 'ViewModel closes the View' question...

Hi all, I'm somewhere in the middle of the learning curve that is the path to MVVM utopia!My question really concerns the ability to close a view from a view model.I don't want to be guilty of trying to force a solution to fit a pattern, but MVVM fits so well in all other areas there's just this one bit left to figure out.The project I'm working on is a system analagous to Microsoft Outlook.You have a main view (window) which has a list of things.These things could be messages or contacts in Outlook.From the main view you have the option to create a new thing or open an existing one.Regardless of which option you choose, a new view (window) opens to present you with a form for editing.From this point on, each new view that opens has the following options (relevant to my question)...1, Save.2, Close.3, Save & Close.Save is pretty straightforward, is just a property on the viewmodel which returns an ICommand (RelayCommand/DelegateCommand).Close is also pretty straightforward, that's just the cross in the top right hand corner of the window.Save & Close, however, is different. With option 2, the close is actually just a part of windows, we're not writing any code to do this.So how would I go about implementing option 3? Where the viewmodel first needs to persist the changes and then needs to close the view?Many thanks,MQCA

tree view OnPrerender Question



Im having the following problem i have a treeview that opens on a pop up window and is being populated from a database table.

What i want is to  add a onClick event to each node as the treeview loads so when i click on a node a javascript function can be called and do something.

How can i take the value of each node that is being populated cause i need to pass it as an argument at the javascript function

public void myTreeView_OnPreRender(object sender, EventArgs e)

        myTreeView.Attributes.Add("onclick", "javascript:doSomething('" + nodeValue + "')");


Thanks in advance


adding mor tables to datasource view causes writeback performance problems


I've got a very strange behavior in one of our SSAS databases. We had performance issues so i've tried to put only the essential parts into one OLAP Database

the result is:

Just by adding more tables to the datasource view the writeback performance drops from 0,2sec to 3 sec. No changes to the cube, no changes to the dimensions.
The t-sql statement fired for the writeback remains the same.
Any idea?



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