BLOGIT.NU - SQL Server


	Login or Register	Home · Articles · Downloads · Your Account · Forums · About

Menu

· Home
· Articles
· Donations
· Downloads
· Forums
· Search
· Sitemap
· Statistics
· Stories Archive
· Submit News
· Top 10
· Topics
· Web Links
· Your Account

Current users

Last articles

· About
· Track the growth of your SQL Databases
· Truncate SQL Transaction Logfiles
· Creating a customized WinPE for Vmware
· Programming the VMware SDK1.x using vbscript
· Cloning a VM using vbscript
· Explanation of Virtual Center's customization process

BLOGIT.NU: SQL Server

[ Go to Home | Select a New Topic ]

SQL Server: Priority Boost setting

Posted by sebastien on Friday 08 December 2006 @ 13:46 (956 reads) (comments? | SQL Server | Score: 0)

By default, the priority boost setting is 0, which causes SQL Server to run at a normal priority whether you run SQL Server on a uniprocessor computer or on a symmetric multiprocessor (SMP) computer. If you set priority boost to 1, the SQL Server process runs at a high priority. This setting does not make the SQL Server process run at the highest operating system priority.

Based on actual support experience, you do not need to use priority boost for good performance. If you do use priority boost, it can interfere with smooth server functioning under some conditions and you should not use it except under very unusual circumstances. For example, Microsoft Product Support Services might use priority boost when they investigate a performance issue.

IMPORTANT Do not use priority boost for clustered servers that are running SQL Server 7.0, SQL Server 2000, or SQL Server 2005.

SQL Server: Remotely Truncate SQL Transaction Logfile

Posted by sebastien on Monday 06 November 2006 @ 15:19 (368 reads) (comments? | SQL Server | Score: 0)

A database running on SQL Server 2000 always has a datafile and a logfile. The problem is that a transaction logfile is never truncated if you don't take a backup of the database. On production servers this is usually not an issue since people take backups. But in test this is sometimes forgotten and then you might run short on diskspace. You may not always have access to the SQL Server console and that's why I created the below script. With this tool you can remotely shrink a transaction logfile to free up some diskspace. Read More...

SQL Server: SQL Server Inventory Script

Posted by sebastien on Monday 30 October 2006 @ 14:56 (428 reads) (comments? | SQL Server | Score: 0)

More and more applications use SQL Server as back-end it becomes important to track the growth of them. Especially when you everything on clustered indexes where diskspace can become a problem if the databases grow to fast. Their are 3th party programs that can track the growth but all the information we need is stored in the master database of a SQL Server. I wrote an Active X Script that runs from a DTS to collect the information from the SQL Servers in your company and bundles all that information in 1 webinterface. This DTS can then be scheduled to run once a week so you get a nice overview. I have taken some screenshots, I will not explain the script step-by-step. All source is open and you ask additional information about it via the forum. Click here for more info.

You can syndicate our news using the file

or ultramode.txt
All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © 2006 by me.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.14 Seconds