Few good commands run from RUN to give information about OS is
msinfo32
msconfig
perfmon
Some sp_readerrorlog
DBCC memorystatus
Wednesday, August 22, 2007
Tuesday, August 21, 2007
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.
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)
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
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)
Wednesday, July 18, 2007
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.
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.
Wednesday, April 11, 2007
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
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
Thursday, November 16, 2006
Interviewing
November 2006
Success with Behavioral Interviewing Questions
Being prepared will lead to confidence and competence
By Leslie Stevens-Huffman
Interviewing for a job can be nerve racking. Even experienced professionals can have a hard time demonstrating their capabilities and expressing themselves effectively, given the tension of an interview situation. The best way to reduce your anxiety and increase your interviewing proficiency, is to eliminate the element of surprise by anticipating the questions you’ll be asked, and preparing some answers.During the interview, you should expect to hear the interviewer ask questions that start with the phrase, “Tell me about a time when.” Or the interviewer might ask a question in this format, “We often have projects where the scope of work changes mid-stream, requiring a great deal of flexibility and adaptability. Can you tell me about a project that you worked on where the scope of work kept changing? How did you handle it?” When you hear open ended questions asking you to describe how you behaved in previous situations, that’s your tip that you are being asked a behavioral interviewing question.Behavioral interviewing questions are the outgrowth of two commonly held theories. The first is that most people succeed or fail in a position not because of their technical knowledge, but because of their behavior and soft skills, and second, those behaviors rarely change over time. By asking you to describe how you have behaved in a similar situation in the past, you will unveil how you will continue to behave under similar circumstances in the future, as well as demonstrating your oral competencies, your ability to think on your feet and handle pressure.
Be a S.T.A.R.
Preparation starts with knowing the types of behaviors the interviewer is likely to inquire about. The list often includes behaviors such as:
Adaptability
Analysis
Attention to Detail
Building Rapport
Building consensus
Communication skills
Decisiveness
Delegation
Flexibility
Independence
Initiative
Integrity
Innovation
Judgment
Listening
Organization
Persuasiveness
Presentation skills
Setting priorities
Teamwork
Technical knowledge and proficiency
Tenacity
Work ethic To prepare, start by reviewing your work history and think about the various situations that have occurred during your experience. Create a list of the vignettes, followed by a list of the behaviors you exhibited in each situation. Knowing the inventory of the behaviors you have exhibited in the past is the first step toward knowing yourself and what type of job you might be best suited for says Dr. Neil Lewis, a corporate consultant and principal of Lewis Associates.“Demonstrating self-awareness and knowing what you are good at and not good at is vital to selecting the right position, and effectively transferring that information in response to behavioral interviewing questions,” says Lewis. The next step is to write the stories that will illustrate your talent. One of the best formats for describing your experiences is the S.T.A.R. technique. Here’s an example:S describes the situation. The IT infrastructure at a local non-profit agency had been implemented in stages, mostly through the efforts of volunteers and with donated hardware. The network was slow, and in the last quarter it was down 30 percent of the time. In addition, the agency staff was bogged down with manual record keeping, but the existing infrastructure was unable to support records management software.T describes the task. I needed to analyze the problems, expand the system capacity and stabilize the network within 30 days with a modest budget.A describes the action you took. After listening to all of the staff’s concerns, I prioritized the needs and rebuilt the network increasing the capacity and reliability. Through my technical knowledge, I was able to save money by recycling many of the components, and by being a bit tenacious with a software vendor, I was able to purchase a records management program at a discounted rate, and I installed it on the system.R describes the result you achieved. The project was completed within 28 days at 5 percent below budget.The next level While not wanting to sound contrived, it is best to practice your stories by telling them to your family, friends or even talking to yourself in front of a mirror. This will increase your comfort level and your confidence, which is important because according to Lewis, roughly 60 percent of your success will be based on how you answer the question- not just the content.There are a few things you can do to take your expertise in relating your experiences to the next level. Add the “V” statement to the end of your story, which stands for validation. This is where you supply the name of a reference who can validate your statements and your success. Also, consider creating an addendum to your chronological or functional resume that describes your experiences using the S.T.A.R. structure. This can be a great accompaniment to your thank you note, and it reminds the interviewer about your story which will help you stand out from the crowd.Tips for handling the unexpected No matter how well prepared you are, sometimes you might be asked a question that you are not immediately prepared to answer. It’s best to take a moment and jot down a few notes before answering.“I would formulate my thoughts before I attempted to give my answer. The interviewer will understand and appreciate the fact that you have gone about it in a systematic way,” says Dr. Eliot Lasson, adjunct professor of Industrial/Organizational Psychology at the University of Baltimore.Lasson says that if you don’t have specific work experience that relates to a question be honest about it, because you will undoubtedly be asked follow-up questions that will require more detail. Also, consider using non-work experiences to validate your behaviors and competencies. Most of all remember that it’s only one question.“If you don’t have an answer, admit it and move on. The truth of the matter is that the interviewer will not always be completely proficient in scoring your answer. Much of the determination of your fit for the job will come down to the chemistry between you and the interviewer,” says Lasson.
Leslie Stevens-Huffman is a freelance writer based in Irvine, Calif. who has more than 20 years experience in the staffing industry.
Success with Behavioral Interviewing Questions
Being prepared will lead to confidence and competence
By Leslie Stevens-Huffman
Interviewing for a job can be nerve racking. Even experienced professionals can have a hard time demonstrating their capabilities and expressing themselves effectively, given the tension of an interview situation. The best way to reduce your anxiety and increase your interviewing proficiency, is to eliminate the element of surprise by anticipating the questions you’ll be asked, and preparing some answers.During the interview, you should expect to hear the interviewer ask questions that start with the phrase, “Tell me about a time when.” Or the interviewer might ask a question in this format, “We often have projects where the scope of work changes mid-stream, requiring a great deal of flexibility and adaptability. Can you tell me about a project that you worked on where the scope of work kept changing? How did you handle it?” When you hear open ended questions asking you to describe how you behaved in previous situations, that’s your tip that you are being asked a behavioral interviewing question.Behavioral interviewing questions are the outgrowth of two commonly held theories. The first is that most people succeed or fail in a position not because of their technical knowledge, but because of their behavior and soft skills, and second, those behaviors rarely change over time. By asking you to describe how you have behaved in a similar situation in the past, you will unveil how you will continue to behave under similar circumstances in the future, as well as demonstrating your oral competencies, your ability to think on your feet and handle pressure.
Be a S.T.A.R.
Preparation starts with knowing the types of behaviors the interviewer is likely to inquire about. The list often includes behaviors such as:
Adaptability
Analysis
Attention to Detail
Building Rapport
Building consensus
Communication skills
Decisiveness
Delegation
Flexibility
Independence
Initiative
Integrity
Innovation
Judgment
Listening
Organization
Persuasiveness
Presentation skills
Setting priorities
Teamwork
Technical knowledge and proficiency
Tenacity
Work ethic To prepare, start by reviewing your work history and think about the various situations that have occurred during your experience. Create a list of the vignettes, followed by a list of the behaviors you exhibited in each situation. Knowing the inventory of the behaviors you have exhibited in the past is the first step toward knowing yourself and what type of job you might be best suited for says Dr. Neil Lewis, a corporate consultant and principal of Lewis Associates.“Demonstrating self-awareness and knowing what you are good at and not good at is vital to selecting the right position, and effectively transferring that information in response to behavioral interviewing questions,” says Lewis. The next step is to write the stories that will illustrate your talent. One of the best formats for describing your experiences is the S.T.A.R. technique. Here’s an example:S describes the situation. The IT infrastructure at a local non-profit agency had been implemented in stages, mostly through the efforts of volunteers and with donated hardware. The network was slow, and in the last quarter it was down 30 percent of the time. In addition, the agency staff was bogged down with manual record keeping, but the existing infrastructure was unable to support records management software.T describes the task. I needed to analyze the problems, expand the system capacity and stabilize the network within 30 days with a modest budget.A describes the action you took. After listening to all of the staff’s concerns, I prioritized the needs and rebuilt the network increasing the capacity and reliability. Through my technical knowledge, I was able to save money by recycling many of the components, and by being a bit tenacious with a software vendor, I was able to purchase a records management program at a discounted rate, and I installed it on the system.R describes the result you achieved. The project was completed within 28 days at 5 percent below budget.The next level While not wanting to sound contrived, it is best to practice your stories by telling them to your family, friends or even talking to yourself in front of a mirror. This will increase your comfort level and your confidence, which is important because according to Lewis, roughly 60 percent of your success will be based on how you answer the question- not just the content.There are a few things you can do to take your expertise in relating your experiences to the next level. Add the “V” statement to the end of your story, which stands for validation. This is where you supply the name of a reference who can validate your statements and your success. Also, consider creating an addendum to your chronological or functional resume that describes your experiences using the S.T.A.R. structure. This can be a great accompaniment to your thank you note, and it reminds the interviewer about your story which will help you stand out from the crowd.Tips for handling the unexpected No matter how well prepared you are, sometimes you might be asked a question that you are not immediately prepared to answer. It’s best to take a moment and jot down a few notes before answering.“I would formulate my thoughts before I attempted to give my answer. The interviewer will understand and appreciate the fact that you have gone about it in a systematic way,” says Dr. Eliot Lasson, adjunct professor of Industrial/Organizational Psychology at the University of Baltimore.Lasson says that if you don’t have specific work experience that relates to a question be honest about it, because you will undoubtedly be asked follow-up questions that will require more detail. Also, consider using non-work experiences to validate your behaviors and competencies. Most of all remember that it’s only one question.“If you don’t have an answer, admit it and move on. The truth of the matter is that the interviewer will not always be completely proficient in scoring your answer. Much of the determination of your fit for the job will come down to the chemistry between you and the interviewer,” says Lasson.
Leslie Stevens-Huffman is a freelance writer based in Irvine, Calif. who has more than 20 years experience in the staffing industry.
Subscribe to:
Posts (Atom)