Windows config commands

Few good commands run from RUN to give information about OS is

msinfo32
msconfig
perfmon


Some sp_readerrorlog
DBCC memorystatus

SQL 2000 Ent Ed and Win 2k3 Ent Ed, 3 GB memory

Recently I had to move huge SQL data base from fast SAN to slow array.

after successfully planning and reducing downtime from two- three days to two hours.

and even online new system we are gotten in to problem of making SQL server use more than 3GB of memory.

From web sites

http://support.microsoft.com/kb/274750

http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56145



Changes I made are

1. in boot file apply /PAE and /3GB switch

[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise" /PAE /3GB /fastdetect /NoExecute=OptOut

2. on SQL server apply AWE and MAX MEMORY LIMIT.

SP_CONFIGURE 'show advanced options', 1
RECONFIGURE
GO

SP_CONFIGURE 'awe enabled', 1
RECONFIGURE
GO

SP_CONFIGURE 'max server memory', 5120
RECONFIGURE
GO


Points to remember:

**PAE switch allows Ent Ed and Data Center Ed, Win Server to use more than 4 GB of Memory(Enable more then 4 GB RAM on 32 bit system)

**/3GB switch restrict the OS to use only 1 GB of memory out of 4 GB (in a 32 bit system). use if switch is preferred when

RAM is 8 GB or Less. so that application can utilize maximum of memory.

When RAM is more than 8 GB, should used /3Gb switch as it effects performance of OS to manage the big memory.

** AWE enable the SQL to use more than 3GB memory when system is PAE enabled.
also you need to specify the max memory used of SQL other wise it eats up all memory and chock the server performance....(leaving only 128 MB for OS)

(Initially posted on Agt 21, 2007)

found the fix
installed was SQLserver 2000 EE sp4(version 2039) and above was known issue to this build.

and upgraded it to SQLserver 2000 EE sp4(version 2040)

Fix: Not All Memory is Available When AWE is Enabled on a Computer Running 32-bit Version of SQL Server 2000 SP4 (899761)

http://www.microsoft.com/downloads/details.aspx?FamilyId=7C407047-3F1F-48B8-9E4C-DC32875E1961&displaylang=en

Soumya ke funde.....

Aim of Life Work as hard as you can.

Make yourself responsible for the more number of task to perform in company.

Talk to people about their job, to know what is going on.

Ask as many Question as you can.

Take initiative.

Talk to Boss as frequently as you can.

Fill free to put up and boast of for you thoughts

Get to know full information of the field you are in.

People should know that you exist in company.

One should have good command on the work he is doing.

Try to out perform.

Spend long hours.............to understand......

and after all this comes the "Smart work"

Be friendly and polite with the colleges.

At the end of day analyze that what you have done and how can you improve your efficiency.

You should not feel relaxed any time, you should have lot of work to do, If you are relaxed then something is wrong with you.

DATABASE Manage/DBA requiremen

DATABASE Manage/DBA requirement

Position will perform, but will not be limited to, the following:
Consults with national deployment team to ensure data are current and accurate across all markets
Design and produce high quality reports that accurately portray market conditions; work with end users to define business requirements and translate them into technical and functional design requirements
Works independently and consults with national operations dbase staff
Strong experience in the architecture, design, and maintenance of Business Objects Xi and Crystal reports. Strong Database background: focus on SQL.
SQL server development experience (Strong TSQL, Stored procedure & DTS skills)
Can write effective SQL statements, stored procedures
Review and optimize SQL statement written by others
Vendor management experience.
Evaluate business requirements, participate in business requirements & functional specifications reviews and select appropriate tool/technology to provide solutions.
Write technical specifications and develop reporting and analytic solutions.
Utilize development skills to build and unit test new reporting/analytic solutions per technical specifications with deliverables to include documented unit test results.
Work with business partners in reviewing prototypes and or other presentation materials as part of the development lifecycle.
Partner with Application Support to ensure proper processes and documentation is provided to support the BI environments.
Educate business partners on tools and data.
Utilize departmental Systems Development Lifecycle Methodology as a guide for development activities.
Assists in enforcement of development deadlines and schedules
Prioritizes multiple tasks effectively
Database performance tuning, as necessary, to maintain efficient use of the application
Use development skills to build and unit test new reporting/analytic solutions per technical specifications with deliverables to include documented unit test results
Use departmental Systems Development Lifecycle Methodology as a guide for development activities
Minimum Required Skills / Competencies: Minimum Required Skills / Competencies:
Bachelors Degree in Business, Engineering, Computer Science or related discipline
Minimum five (5) years of application development skills
3+ years as a DBA
Excellent working knowledge/ certification of MSSQL enterprise
Demonstrated experience in the architecture, design, and maintenance of Business Objects Xi and Crystal reports; certification a plus

Preferred skills: Graphic design / layout / user interface competencies (i.e. Photoshop e