.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

SQl server cache allocation

Posted By:      Posted Date: September 17, 2010    Points: 0   Category :Sql Server
 
Hi Can anyone tell me 1.  how the sql server allocates its cache (sql 2000, 2005, 2008) 2. Is there any way to access this value(Cache) 3. Is there any way(Query,Formula) which tells how much percent of cache allocated will be used as a     procedure cache? ThanksAnshul Jain


View Complete Post


More Related Resource Links

Server Cache Issue - .Net 2.0 / Oracle 11g / 2003 Server / IIS 6.0

  
Hi All,We are working on a web application developed in C#, nHibernate and with Oracle as back-end.WebServer and Database are on different machines.Application is more or less accessed by 500 users all the time.Recently we found that some of the controls within MultiView Tab contol were not working as expected. Basically, data is not getting saved.For instance, if there are 5 tabs and in the first tab if we change an option in the dropdownlist, in the autopostback event, the new value should get saved to database. If we navigate to another tab and visit the previous tab, the new option should remain there (reloading the data in the page_load, preRender events).But once we restart the IIS, all this functionality works as expected.Even if there is some database issue, like foreign key violation etc, application is behaving weirdly and once we fix the database issue, we still need to restart IIS to clear cache for the application to behave normally.I am not sure if any of you ever faced this issue but please let me know where to start analyzing this issue?Thanks in advance.ys

Report server cache vs RAM

  
Hello, When report server executes a huge report(or any small or big report), it consumes some amout of RAM available on the server box. Once the report is completely executed, does it releases the RAM that it used for report execution? Does RAM goes to the original level after complete report execution? When the report is cached, does this cache memory something different from the available RAM on the server box? If so, from where this cache memory comes from? Regards.

SQL Server 2005 buffer cache

  
Hello! I try to find out what objects use buffer cache. As example, in Oracle there is fixed table x$bh. This table gives us infomation about buffer cache on per block basis. Is there similar view or table in SQL Server 2005? How can I find out what table uses most of buffer cache?

Cache-SQL Server SSIS

  
I have a odbc connection to a Cache' DBMS and I connect via ADO.NET in my SSIS package. Now, I have a query that is executed perfectly when I connect directly to my Cache' database however in SSIS it returns nothing. This is because in runtime the '-' in my datetime is being converted to '/' by sql server. Any workaround to get the '-' to persist in my query?

ADO Recordset server-side forward-only, read-only cursor asynchronously cache all records?

  

We are using ADO, and currently create our recordsets using adUseClient and adOpenStatic since that way we can guarantee all the results will be loaded from the server and cached into the client memory without holding locks open on the server. 

However there are great performance benefits to adUseServer and adOpenForwardOnly! I have tried using adAsyncFetch and adAsyncExecute to load things in the background when necessary.

Unfortunately the trouble is that despite the value that I've set the CacheSize to, when the recordset is opened it does not load all of the records into memory. This is a concern since some operations on each record in the client application may take a while or even block waiting on user input. While this occurs, this holds locks on the tables in SQL Server until we read through all the records.

I have tried setting CacheSize to see if it would load everything all at once, but to no avail.

Since all the pieces seem to be here, I don't quite understand why the server-side cursor can't simply load everything into memory in the background the same way the (static) client-side cursor does.

I've tried some of the recordset's dynamic properties (like Maximum Open Records, which is readonly) to no avail either.

I know ADO is a bit dated now, but I would be overjoyed if anyone could guide me to a solution

Desable Cache of asp.net remote server iis

  

Hello

How can i delete cache of asp.net remote server cache.


call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter

Determine whether Forms Server is installed on a server

  
Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.

Connestion string create any database server

  
This links important to how to create connection string to any data base sever.

SQL Server Database Transaction

  
A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:
Categories: 
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