Hi,
I found "FETCH adjust_identity INTO @objid" has big logic reads in my system. Is it a system query? is it a problem to have big # logic reads for this? Please advice.
Thanks...
View Complete Post
Ent : SQL Server 2008 SP17
OS : Windows Server 2008 Ent.Edt
While troubleshooting a performance issue for a Query (SP) I came across this weired thing that the Query Plan handle is not matching across all the Query related system DMV’s.
Senario with a simple query
For each executing Query a plan handle is generated in sys.dm_exec_connections (Column most_recent_sql_handle).Based on the sql_handle the q
Hi
I have a .NET application executing a stored procedure on a SQL Server 2008 SP1 64 bit instance (version 10.0.2531.0), and getting the following exception:
There is insufficient system memory in resource pool 'internal' to run this query.
Maximum server memory is set to 4096MB. The server has 4GB of physical RAM available, and is running Windows Server 2008 R2 x64.
The SQL Server instance is only consuming approx 1.5GB RAM and there is 15+% physical RAM unused.
The messages in error.log are as follows:
2010-09-25 03:28:38.15 spid51 Failed allocate pages: FAIL_PAGE_ALLOCATION 1 2010-09-25 03:28:38.15 spid51 Memory Manager KB ---------------------------------------- ---------- VM Reserved 4277792 VM Committed 1532212 Locked Pages Allocated 0 Reserved Memory 1024 Reserved Memory In Use 0 2010-09-25 03:28:38.15 spid51 Memory node Id = 0 KB ---------------------------------------- ---------- VM Reserved 4276704 VM Committed 1531184 Locked Pages Allocated 0 MultiPage Allocator 38992 SinglePage Allocator 1371648 2010-09-25 03:28:38.15 spid51 MEMORYCLERK_SQLGENERAL (node 0) KB ---------------------------------------- ---------- VM Res
Somebody know what kind of Error is "There is insufficient system memory in resource pool 'internal' to run this query."
how to query the system date in selectcommand in gridview without using the codebehind. using c# .net
anyone???
my code:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" SelectCommand="SELECT * FROM tablename where date_today = <SYSTEMDATE>" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
hello i have the following problem
i have upload my content to hosting server but i get the following error
Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SecurityException: Request for the permission of typ Problem upgrading to MVC3 - System.Web.Routing Hi,I'm trying to upgrade to .NET 4 and MVC 3.When trying to compile my project, I get the error:Error 1 The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?) C:\Users\spencer\Desktop\weblauncher\Common\MVCConfig.cs 4 18 Common The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)I do have the System.Web.Routing in my references for the project.BUT - when I try to view System.Web.Routing in the OBJECT BROWSER, nothing is inside! The System.Web.Routing namespace is not in there - the entire thing is empty! Could it that the dll is corrupted? I tried to reinstall the .NET 4 and MVC 3 stuff, but its still empty!The dll is coming from here:C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\System.Web.Routing.dlland the runti System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPerm Good Day all,Having an issue with an outside user accessing my IIS7 box. I do not have this problem when running the website from my host machine. I found this post: Http://forums.asp.net/t/1371394.aspx. I assure you that this is not a solution because I am not storing any of my files on a network share. What do you think my approach should be. I already have read rights to IIS user to my BIN folder. Thanks for the help. System.IO.Packaging is not visible I am new to ASP.net, I installed VS2005 and IIS 5 on my PC and set up my first website using IIS (not the embedded webserver in VS).For some reason I cannot find the Assembly: "System.IO.Packaging", please let me know if I am allowed to use it in that medium and how can I reference it?Thanks in advance. how i can install sql server in my system which edition of sql server are best for me Developer edition or express editon for development purpose.i try to install last time sql server in my system but not successful so what i do for get the sql server in my system. sql query that don't run Hello....I'm going crazy... i've got a piece of code that don't update the database... Could somebody tel me why it doesn't run??Dim conn As SqlConnection Dim cmd As SqlCommand Dim cmdstring As String = "Update Corsi Set [Contenuto]='" & TxtText.Content & "' Where [ID]='" & Request.QueryString("Id").Replace("'", "") & "'" conn = New SqlConnection(SqlAnni.ConnectionString) cmd = New SqlCommand(cmdstring, conn) Need help with a linq to sql query I want to display some stats in a listview contril. The table contains a record for every impression and for every click, and every record has a datetime field for the time and date of the impression of click. I want to be able to display how many impressions and clicks there were in a given day and hour, something like below:Date Time Impressions Clicks8/20/2010 450 14 Midnight -1:00am 150 5&n Categories: ASP.NetWindows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[SecurityException: Request for the permission of typ Problem upgrading to MVC3 - System.Web.Routing Hi,I'm trying to upgrade to .NET 4 and MVC 3.When trying to compile my project, I get the error:Error 1 The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?) C:\Users\spencer\Desktop\weblauncher\Common\MVCConfig.cs 4 18 Common The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)I do have the System.Web.Routing in my references for the project.BUT - when I try to view System.Web.Routing in the OBJECT BROWSER, nothing is inside! The System.Web.Routing namespace is not in there - the entire thing is empty! Could it that the dll is corrupted? I tried to reinstall the .NET 4 and MVC 3 stuff, but its still empty!The dll is coming from here:C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\System.Web.Routing.dlland the runti System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPerm Good Day all,Having an issue with an outside user accessing my IIS7 box. I do not have this problem when running the website from my host machine. I found this post: Http://forums.asp.net/t/1371394.aspx. I assure you that this is not a solution because I am not storing any of my files on a network share. What do you think my approach should be. I already have read rights to IIS user to my BIN folder. Thanks for the help. System.IO.Packaging is not visible I am new to ASP.net, I installed VS2005 and IIS 5 on my PC and set up my first website using IIS (not the embedded webserver in VS).For some reason I cannot find the Assembly: "System.IO.Packaging", please let me know if I am allowed to use it in that medium and how can I reference it?Thanks in advance. how i can install sql server in my system which edition of sql server are best for me Developer edition or express editon for development purpose.i try to install last time sql server in my system but not successful so what i do for get the sql server in my system. sql query that don't run Hello....I'm going crazy... i've got a piece of code that don't update the database... Could somebody tel me why it doesn't run??Dim conn As SqlConnection Dim cmd As SqlCommand Dim cmdstring As String = "Update Corsi Set [Contenuto]='" & TxtText.Content & "' Where [ID]='" & Request.QueryString("Id").Replace("'", "") & "'" conn = New SqlConnection(SqlAnni.ConnectionString) cmd = New SqlCommand(cmdstring, conn) Need help with a linq to sql query I want to display some stats in a listview contril. The table contains a record for every impression and for every click, and every record has a datetime field for the time and date of the impression of click. I want to be able to display how many impressions and clicks there were in a given day and hour, something like below:Date Time Impressions Clicks8/20/2010 450 14 Midnight -1:00am 150 5&n
I'm trying to upgrade to .NET 4 and MVC 3.
When trying to compile my project, I get the error:
The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)
I do have the System.Web.Routing in my references for the project.
BUT - when I try to view System.Web.Routing in the OBJECT BROWSER, nothing is inside! The System.Web.Routing namespace is not in there - the entire thing is empty! Could it that the dll is corrupted? I tried to reinstall the .NET 4 and MVC 3 stuff, but its still empty!
The dll is coming from here:
C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\System.Web.Routing.dll
and the runti
Good Day all,
Having an issue with an outside user accessing my IIS7 box. I do not have this problem when running the website from my host machine. I found this post: Http://forums.asp.net/t/1371394.aspx. I assure you that this is not a solution because I am not storing any of my files on a network share.
What do you think my approach should be.
I already have read rights to IIS user to my BIN folder.
Thanks for the help.
I am new to ASP.net, I installed VS2005 and IIS 5 on my PC and set up my first website using IIS (not the embedded webserver in VS).
For some reason I cannot find the Assembly: "System.IO.Packaging", please let me know if I am allowed to use it in that medium and how can I reference it?
Thanks in advance.
which edition of sql server are best for me Developer edition or express editon for development purpose.
i try to install last time sql server in my system but not successful so what i do for get the sql server in my system.
Hello....
I'm going crazy... i've got a piece of code that don't update the database... Could somebody tel me why it doesn't run??
I want to display some stats in a listview contril. The table contains a record for every impression and for every click, and every record has a datetime field for the time and date of the impression of click. I want to be able to display how many impressions and clicks there were in a given day and hour, something like below:
Date Time Impressions Clicks8/20/2010 450 14 Midnight -1:00am 150 5&n
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend