Solved

Suggested settings for "Processor Scheduling" & "Memory Usage"

Posted on 2007-11-29
2
2,730 Views
Last Modified: 2013-12-09
Deltek Vision is basically an accounting / Project management program running ontop of SQL Server 2005. What is the prefered settings for "Processor Scheduling" & "Memory Usage" for this type of system.

Right now I have this set to the same as my Exchange server, that is "Backgrouns Services" & "Programs" respectivly (which I found from an answer to another persons question in this forum).

Also: with 4 Gig of RAM, I did not think I needed the full 1.5 times for swap file, so I left the swap file a 3 Gb.

Thanks in advance!
0
Comment
Question by:RKoons
2 Comments
 
LVL 35

Accepted Solution

by:
David Todd earned 200 total points
ID: 20379256
Hi,

There isn't any harm from a SQL point of view of having a large swap file. Ideally SQL wont use it much.

But I've seen that MS recommends a minimum page file of the same size as memory. Why don't you set it with a range between 4GB and 6GB and let Windows manage it in that range.

Yes, Definitely go for Background Services, but I would have thought that System Cache would have been the better optioni for the Memory setting.

Cheers
  David
0
 
LVL 1

Author Closing Comment

by:RKoons
ID: 31411798
Simple question... Simple answer... Thanks
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now