Security - a major ingredient for every Enterprise to avoid the adversaries attempt to invade your customers’ networks and access their servers—to bring them down, infect them with viruses, or steal information about customers or employees, every day! The recent release of Windows Server 2008 from Microsoft...
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications An additional resource group that contains no resources is created after you install a second...
Originally known as "TS Rail", the RemoteApps feature of Windows Server 2008 makes Terminal Servers an absolute essential on everyone's network. There is no way I won't have a TS running full time from here on out, and RemoteApps is the reason. So, what's so cool about it? Utter...
The Windows Home Server Team Blog announced that Microsoft will soon be releasing (H1, 2008) a free, automatic, upgrade to Windows Home Server called "PowerPack 1" (PP1 for short.) PP1 has lots of new features I think are important, including a new option for backing up the server itself to...
We have most of our database systems on 64-bit environment, but one of the application user asked the question what is the advantage of a 64-bit environment in relation to SQL Server application. I would say with the evolution of SQL Server 2005 it has opened many more differentiation between 32- and...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
12-19-2007
Filed under: sql server, package, management, microsoft, server, windows, best practices, 2008, consolidation, planning, x64, 2005, advantages, policies
Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must test the implications and usage in hiking such a...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
11-15-2007
Filed under: sql server, performance, microsoft, server, tuning, dbcc, system, best practice, testing, resources, sqlperf, max worker threads
We have been going through a load-performance exercise for an application that will have more than 5000 concurrent connections at one time. Going by books and expeirence by default the Max Worker Threads setting is 255, which means that up to 255 worker threads are allowed to be created. Most of the...
So, in Part 1 I talked about the whole process of borrowing and setting up my EqualLogic PS3800XV SAN. Now that I've got it powered up, I needed to add IP addresses for it, and connect to it. Setting IP addresses is straightforward - you can let DHCP handle it, or use the provided null modem cable...
In order to write about Storage Area Networks (SANs), you really need to have access to a SAN. Now if I had an unlimited budget, I'd happily have set up a SAN here in my office, if only for the simplicity and the ability to centralize storage across all the computers here. And with an iSCSI SAN,...
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Error message when an application connects to SQL Server on a server that is running Windows...