.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

buffer manager free pages decrease though the sql server has a lot memory

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Sql Server
we found the backup frequently fails due to insufficient memory, when checked the buffer memory, found it always decreases, can we purge something in buffer to free more pages?

View Complete Post

More Related Resource Links

Non-buffer pool memory in the SQL Server memory space on 64-bit system

Is there a way to tell the amount memory not allocated to the buffer pool within the SQL Server memory space on a 64-bit system?
e.g. to the SQL CLR.

Make everything as simple as possible, but not simpler.
-Albert Einstein

Cutting Edge: The Server Side of ASP.NET Pages


Where are the files generated by ASP.NET stored and how are they used to serve page requests? This month Cutting Edge explains.

Dino Esposito

MSDN Magazine January 2007

Active Server Pages+: ASP+ Improves Web App Deployment, Scalability, Security, and Reliability


ASP has been rebuilt from the ground up. The result? Active Server Pages+. ASP+, with a host of new features, provides for easier to write, cleaner code that's simple to reuse and share. ASP+ boosts performance and scalability by offering access to complied languages; development is more intuitive thanks to Web Forms; and an object-oriented foundation facilitates reuse. Other important features include page events, Web Controls, and caching. Server Controls and improvements in data binding are also new with ASP+. Libraries for use with ASP+, and the Microsoft .NET Framework which allows custom business functions to be exposed over the Web, provide more new development opportunities.

Dave Sussman

MSDN Magazine September 2000

Using Server-Side XSL for Early Rendering: Generating Frequently Accessed Data-Driven Web Pages in A


Dynamic data-driven pages have become the basis of many cutting-edge Web sites. Early render systems can provide better performance and maintainability for data-driven Web sites by generating frequently accessed pages that contain less-volatile information ahead of time. We'll show you an example of a server-side solution that uses Extensible Stylesheet Language (XSL) to merge data and layout information into HTML that is compatible with just about any modern Web browser. Using these techniques to render Web pages early can reduce the load on your database back end and increase performance for your users.

Paul Enfield

MSDN Magazine April 2000

Displaying the Server Ribbon and Site Actions Menu on Customized Search Pages Upgraded to SharePoint

Learn how to add the Site Actions menu and SharePoint Server ribbon to SharePoint Server 2007 search pages that you upgrade to SharePoint Server 2010 by using visual upgrade.

Generating and storing html pages in User Directories on the server



I come from corporate asp.net development, and I am now working on a public website which will get a lot of traffic, perhaps a million users a day.  So I am faced with a ton of performance and scalability questions.

I would like to share some thoughts and see if my approaches resonate with any good practices, or perhaps I am heading down the wrong path...  Either way, I want to hear opinions.

(My number one concern is the fact that I am using asp.net for a public website.  I don't know of a lot of websites using asp.net)

I am using asp.net 2.0 (I know, its not the latest technology but I don't need any advanced features of asp.net 3.5 or 4, unless there are significant improvements geared towards what I am doing) 

On launch date, this will be running on a dedicated Windows Server 2008 running on Intel ATOM 330 1MB L2 Cache 1.6Ghz Dual-Core with 2GB DDR RAM.  Its fully managed by a full service hosting company which gives me an option to upgrade to a bigger server within a few hours.  I can even move the site to a webfarm if the traffic demands it.

So I have a User Dashboard, where users can create albums and upload pictures.  So what I am doing

SQL Server Configuration Manager Exception: 0x80010105

We're running SQL Server 2008 Standard edition version 10.0.2531.0 (SP1) 64-bit.  It is running on Windows Server 2008 R2. Whenever I connect to the SQL Server Configuration Manager, and look at the SQL Server Services, I get the message : The server threw an exception. [0x80010105]. Suggestions?Clint

SQL Server Configuration Manager: Connection to target machine could not be made in a timely fashion

I have a SQL Server 2005 box that was moved from a domain environment to a non-domain environment and was never dropped from its original domain before moving over.  Subsequently a new domain was created at the data center this SQL Server box now resides in.  The machine was dropped from its old domain and joined to the new one.   All the while the service accounts were set to the local admin account.  When I tried to start the Configuration Manager I got the message "Connection to target machine could not be made in a timely fashion.".  I read some blog entries and tried changing all the service accounts to Local System and the error message still came up.   All of the SQL Server services run fine.  It is just this management console that I cannot open.  I wasn't with this employer when this box was moved to the data center so I do not know if it worked prior and there isn't anyone here that could give me its history.   Any help would be appreciated.

unable to create new table in sql server 2000 enterprise manager on windows7(Operating system)

i have successfuly installed sql server 2000 on windows7 and i am able to browse all the tables and edit aswell(on enterprise manager) but i have a problem while creating new tables it says ' MMC has detected an error in a snap-in' and provides options to either continue with the error or send a report to microsoft ,   Please help regarding this compatibility issue   Thanks in advance !

WmiPrvSE.exe causes a huge memory leak in SQL server 2008 R2, why?

My OS is windows server 2008 r2 data center 64 bit and my SQL server is server 2008 R2. The problem is when I open sql server, the WmiPrvSE.exe process consumes 20 - 60kbs every second. Several hours later, it eats up at least 200mbs memorry and this process seems like it will never stop. Can any experts give me some ideas to fit this mess? PS: My mainboard is Asus striker II formular, cpu is intel quad-core. Also, all my software are updated to latest version.

SQL Server Configuration Manager - Protocol Name is blank

When I run SQL Server Configuration Manager (2008) and click on SQL Server Network Configuration and then Protocols for SQL, the right side of the screen shows the protocol icons and their status, but the names (TCP/IP, Shared Memory, Named Pipes, etc) are not there. Can someone tell me how to get the names to display again? They used to show up. A thought is that I installed XP SP3 and that made them go away, but I can't prove that.

SQL server memory / speed configuration

Let me preface this by saying I'm aware of SQL server memory architecture, i.e it takes as much as it can get it's hand's on ...I've read through all the post's on here and they have been very helpful ... However if someone could take a look at these these configuration values ... I'm trying to get a new server dialed in, I'm still having some user end speed issues, and application hangup's that seem sql related ... I'm by no means a dba so if someone who's knowledgeable could point me in the right direction I would appreciate it ... I feel like something is not configured properly ... The box has Microsoft SQL Server 2008 (RTM) 64-bit on Windows NT 6.0 <X64> Service Pack 2 Dell Power Edge R10 16 Logical CPU, 8 Hyperthread 12gig of memory (Right now SQL has 10/12 gig allocated in the task manager ( I know this is not accurate ) I'm adding another 12 gig tomorrow ... So the machine will be running 24 gig) There's two 9 gig databases running on the machine with several 4-6 million row tables .... Server is SQL Dedicated Configuration Values   Page Life Expectancy 18,038 under moderate load, tho I've seen it as low as 1,200 under heavy load .... Buffer Pool Usage CACHESTORE_SQLCP 2778616 OBJECTSTORE_LOCK_MANAGER 38816 MEMORYCLERK_SOSNODE 20936 CACHESTORE_OBJCP 18992 CACHESTORE_PHDR 16472 USERSTORE_SCHEMAMGR 12184 USERSTORE_DBMETADATA 8264 USE

SQL Server Management Studio - Invalid access to memory location

In SQL Server Management Studio (for SQL Server 2008), when I try to open a new query window, or create a new database, I get a popup error box saying the following: "Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (mscorlib)" This just started happening in the last few days, and I have no idea why.  I even uninstalled SQL Server 2008, and then installed SQL Server 2008 R2, and continued to get the exact same error, in the exact same scenarios. Please let me know if you have seen this before, and what I might try to correct it. Thanks, Robert  

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?

How to upload a URL link into Report Server using Report Manager?

Hi I would like to have a URL link in Report Server that directs to one of our directory folder that has a history of pdf reports. I want to know if its possible to do this by just having to upload the URL link into Report Server, like we upload the .rdl files using Report manager. Is there any way to do this? Please let me know. Thanks

Permission Errors for Users on Home Page only of SQL Server Reporting Services Report Manager

I have spent days now investigating this problem, so any help very much appreciated! I have a remote web server 2003 running SQL Server R2 Express Edition with Reporting Services installed. I use Report Builder 3.0 locally to build report. If I login via Internet to Report Manager Web Page as an administrator I can perform all the expected and required actions, creating new folders and assigning permissions for users etc. I have added a new user "ReportUser" as a Browser of a child folder. If ReportUser longs on to home page, he receives the all too familiar error: User 'XXXXXXXX\reportuser' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. However, if the user starts at the child folder of home page, and then logs in, he sees the expected page, and can run the report!  This is not very satisfactory. How can I allow user to see home page, without an error message, but not be allowed to click on any folders to which he is not entitled? I am now aware that SQL Server R2 Express Edition has many limitations compared with full Editions (fixed roles, cannot manage Report Service from Management Studio etc) , and many of the "solutions" offered on the web just do not apply.   John Walton
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