:::: MENU ::::

Posts Categorized / Hardware and Platform

  • Dec 06 / 2011
  • 0
dbDigger, Hardware and Platform, System Administration, Windows 7

How to uninstall an SQL Server instance out of multiple instances

While writing an article for MSSQLTips.com, i installed SQL Server 2005 Dev Edition and SQL Server 2005 Express Edition on Windows 7. Dev Edition was with default instance name while Express Edition was named as SQLExpress on machine. After completion of article as a clean up process, it was required to uninstall the express edition.

During this process i noticed that for new DBAs uninstalling an instance out of multiple instances may be confusing if not aware of process. In add/remove programs utility, SQL Server instances are embedded in their versions rather than separate entry for each instance. SQL Server 2005 instances are included under Microsoft SQL Server 2005 entry while SQL Server 2008 instances are included under Microsoft SQL Server 2008 entry.

Uninstall SQL Server 2005 Express edition

So here is how i uninstalled express edition and leaving the Dev edition only in SQL Server 2005 family.

  • Click on Microsoft SQL Server 2005 entry
  • On generated frame select SQL Server 2005 express instance to uninstall
  • Make sure to leave the common components unchecked

Uninstall SQL Server 2005 Express edition from Windows

Now click the Next button to continue with uninstall of selected instance of SQL Server 2005.

  • Oct 27 / 2008
  • 0
DBA Interview questions, dbDigger, Hardware and Platform, Performance Tunning and Optimization

Scenarios when SQL Server 2000/2005 64-bit is recommended

Microsoft had provided 64-bit support since SQL Srever 2000. So for SQL Server 2000 and SQL Server 2005 DBA always have a choice to choose the 32-bit version and 64-bit version. 64-bit supported hardware is primary requirement. As 32-bit SQL Server can be used on 64-bit architecture machine, so it becomes a matter of choice to choose between the two SQL Server architectures. There are some very specific scenarios in which it becomes highly recommended to use SQL Server 64-bit

  • When number of concurrent users and sessions are in thousands
  • Database is over 100 GB
  • Database is heavily growing
  • If going to buy new system, its better to migrate on 64-bit platform rather to adopt it later with more changes required.

Click here to read all posts related to Hardware and OS related to SQL Server

  • Oct 27 / 2008
  • 0
dbDigger, Hardware and Platform, Performance Tunning and Optimization, Storage

Windows Server 2003 for SQL Server 2005 with 32-bit and 64-bit architecture

Windows Server 2003 is available for X86, X64 and Itanium platforms. SQL Server 2005 is available for Windows Server 2003 for 32-bit architecture, Windows Server 2003 for 64-bit architecture and Windows Server 2003 for Itanium. Clustering is greatly developed in Windows Server 2003.

Windows Server 2003 comes in a variety of editions, including

* Standard Edition
* Enterprise edition
* Datacenter Edition

The edition of window server 2003 that you choose depends upon number of required CPUs and amount of memory required. It is possible to use SQL Server 2005 32-bit on windows server 2003 64-bit, but you can not use SQL Server 2005 64-bit on windows server 2003 32-bit obviously.

Click here to read all posts related to Hardware and OS related to SQL Server

  • Oct 27 / 2008
  • 0
DBA Interview questions, dbDigger, Hardware and Platform

Hardware Platforms for SQL Server 2005

SQL Server 2005 is supported on following three platforms

* X 86 platforms (32 bit)
* X 64 (X86-64) platforms (64 bit)
* And Itanium platforms (64 bit)

X86 and X64 chips are with same architecture while Itanium uses a different architecture.

X86
X86 can access physical memory up to 64 GB using PAE and AWE and 4 GB of virtual memory. Intel and AMD have introduced processors that support both X86 and X64 architectures on same machine.

X64
X64 can access up to 1-4 terabyte of physical memory and 256 terabyte of virtual memory. X64 is flexible platform, can work as 32-bit or 64-bit depending upon what operating system is installed. If 64-bit OS is installed even then 32-bit applications run. For SQL Server 2005, it is recommended that 64-bit version of SQL Server 2005 should be used with 64-bit OS (Windows Server 2003).

Itanium
Itanium architecture is also known as IA-64 architecture. It can address physical memory up to 1 petabyte with 50-bit physical addressing mode. Virtual memory up to 60 exabyte may be addressed in 64-bit addressing mode. Microsoft has also introduced versions of Windows XP, Windows 2000 and Windows 2003 for Itanium processors. So SQL Server 2005 64-bit may be used on Windows 2000 and Windows 2003 on Itanium. A version of SQL Server 2000 is also available for Itanium but only with server components.

Click here to read all posts related to Hardware and OS related to SQL Server

  • Oct 27 / 2008
  • 0
dbDigger, Hardware and Platform

Advent of X 86 processors family

Along with advancement in various fields of IT and information systems. Hardware has also under gone major changes in last few years. Along with updates of going on advancements, it is also important to have knowledge about the revolution from its early days. Here i have summarized the X-86 family which is now being replaced by members of X-64.

X-86 processors emerged in late 70’s.

The first member of this family came as Intel 8086 processor. Intel 8086 was introduced in 1978 and Intel 8086 was a 16 bit processor.

Intel 8086 was followed by Intel 80186 and Intel 80286 processors of X86 family. Both Intel 80186 and Intel 80286 were 16-bit. However with some sophisticated technology at that time Intel 80286 was able to access up to 16 MB of RAM.

Intel 80386 processor was introduced in 1986, and is considered as third generation of X86 chips. Intel 80386 was also known as Intel i386. Intel 80386 introduced 32-bit processing capabilities. Intel 80386 also had virtual memory architecture and it made possible to access up to 4 GB of RAM.

It took 8 years to switch from 16-bit architecture to 32-bit architecture. But to turn on to 64-bit architecture from 32-bit architecture took 20 years. In 2006 64-bit processors began to replace the 32-bit architectures.

Click here to read all posts related to Hardware and OS related to SQL Server

Pages:12
Consult us to explore the Databases. Contact us