SQL Server a lot of Single use objects -

-

We have a database with approximately 50-60% recompilation, this value [batch request / sec] together with [SQL] Coming / Seconds] comes from

We feel that this value is slightly

If we look at this question: / P> 

  SELECT.dll_exec_sql_text (qs.sql_handle) ST WHERE qs apply the. Plan_generation_num & gt; 1 ORDER plan_generation_num DESC

If you compare it to performance count then we do not have many plan_generation_num, we have the same object of use and why am I trying to understand it ?

There is an application created in our ASP.NET and we always use the parameters that are queryed. We use both SP and SQL-statement in the application, but are always parametida.

The webpage that is running this database again is a very large website, approximately 500 000 pageviews per day and approximately 10 000 requests per minute if this information helps.

We do not have long-lasting questions and indexes and Statistics is in order. This is one of the last things to optimize.

CPU average 15% of RAM is about 100 GB and is the curl used by SQL-server. We use SQL Server 2014 Enterprise.

One thing I started thinking about the beginning. If I have such a SQL statement 

  choose seats from windows, cars where wheels = @ vahillas and activate = 1

Is it The plan is not to be reused, we do not set a parameter on this part: ** and activate = 1 **

How to get any idea about how we are so alone Why use? Calculation on cached plans is approximately 20 000. In comparison, we have around 700 SP 'and many more questions in the app.


Comments

Post a Comment

Popular posts from this blog

winforms - C# Form - Property Change -

-
I have a form that has a property named car A class with many properties. The Properties is being displayed on the current car on the basis of some user actions that are being displayed. So I have to know whether the property has been allocated or set to zero. I'm aware of INotifyPropertyChanged , but in my case I'm not sure that since this change I have changed my car properties car do not want to monitor the property. Any idea how to accomplish this? In advance thank you If you have created a true asset in your class then You should be a great and setter, you can add the code directly to the form property in order to take action on the basis of "form": Public partial category Form 1: form {public form 1 () {InitializeComponent (); } // define car square public class car {public string name = string. Empty; } // private car to keep the value of the current car private variable _car = null; // Property of public form which you can ru...
Read more

java - Messages from .properties file do not display UTF-8 characters -

-
Image
In the form of a title, I can only add that if I enter the html file manually, then it Okay. View Rolver: & lt; Bean id = "templorellolver" class = "org.thymeleaf.templateresolver.ServletContextTemplateResolver" & gt; & Lt; Property name = "prefix" value = "/ web-nf / templates" /> & Lt; Property name = "suffix" value = ". Html" /> & Lt; Property Name = "Template Mode" Value = "HTML5" /> & Lt; Asset name = "cacheable" value = "wrong" /> & Lt; Property Name = "characterEncoding" value = "UTF-8" /> & Lt; / Bean & gt; & Lt; Bean id = "Template Engine" class = "org.thymeleaf.spring3.SpringTemplateEngine" & gt; & Lt; Property Name = "Temploreolar" ref = "Templarolver" /> & Lt; / Bean & gt; & Lt; Bean square = "org.thymeleaf.spring3.view.Thymel...
Read more

javascript - amcharts makechart not working -

-
I am trying to create an amiratars serial chart on my Durandal single page application. This chart was working fine on Chrome browser but it is not working on IE. Can you please help me in this regard. Error while using Amcharts. The Macchart () method does not support the object in this object in IE.
Read more