Posts Tagged ‘70-443’

What is the SystemProcessor Queue Length counter?

September 30th, 2009

The SystemProcessor Queue Length counter displays the number of threads ready in the processor queue but not currently able to use the processor. The Processor: %Processor Time counter should be measured with a counter. If its value is two, it indicates a CPU bottleneck. This results in slow performance of the server. To eliminate the performance problem, several steps can be used such as reducing the number of processors, using = multiple processors, updating the processors, or installing new and updated CPUs.

  • Share/Bookmark

What are the types of capacity planning?

September 30th, 2009

The following are the types of capacity planning:

  • Preconfiguration capacity planning: This capacity planning involves the planning and implementation of hardware resources that will be used to accomplish a given task.
  • Share/Bookmark

Replication

September 29th, 2009

Replication is a type of configuration used to copy data and database objects from one database instance to another. A database administrator has to configure a server for replication, and monitor it in order to detect and resolve issues regarding replication.

Requirements for replication: The following roles are required for replication configuration:

  • Share/Bookmark

What is Database Engine Tuning Advisor?

September 3rd, 2009

Database Engine Tuning Advisor is a tool that tunes a database for better query performance by analyzing a workload that is a set of T-SQL statements. It suggests clustered indexes, nonclustered indexes, indexed views, and partitioning. Database Engine Tuning Advisor in SQL Server 2005 replaces the Index Tuning Wizard of SQL Server 2000. This tool provides two user interfaces: a graphical user interface (GUI) and the dta command prompt utility.

  • Share/Bookmark

What are the disadvantages of database server consolidation?

August 21st, 2009

The disadvantages of database server consolidation are as follows:

  • It requires high-availability options and failover clustering.
  • It results in the performance deterioration of the server.
  • It requires a disk with high storage and high input-output capacity.
  • It requires more memory.
  • Share/Bookmark

What are SQL Server Securables?

August 21st, 2009

SQL Server Securables contains three scopes, which are used to assign permissions to users. The securables are nested and each securable contains various other securables. The securable scopes are as follows:

  • Server: It includes server roles, logins, etc.
  • Database: It includes database users, application roles, database roles, etc.
  • Share/Bookmark

What is the IS_SRVROLEMEMBER function?

August 21st, 2009

The IS_SRVROLEMEMBER function provides information about whether or not a login is a member of a specific role. A database administrator can use this information to assign permissions to users. The syntax of using the function is as follows:

IS_SRVROLEMEMBER (’role’, ‘login’)

  • Share/Bookmark

Joins: Its Types and Uses

August 21st, 2009

The JOIN clause is used with the SELECT statement to retrieve data from more than one table. This clause matches data from multiple tables. This results in the creation of a table, which is a combination of columns from multiple tables.

  • Share/Bookmark

How to create a partition for an existing table and index?

August 21st, 2009

Take the following steps to create a partition for an existing table and index:

  1. Create a partition function: A partition function can be created by using the CREATE PARTITION FUNCTION STATEMENT. An example is given below:

    CREATE PARTITION FUNCTION myfunc
    RANGE LEFT FOR VALUES(100, 200, 300)

  • Share/Bookmark

What are the types of capacity planning?

August 20th, 2009

The following are the types of capacity planning:

  • Preconfiguration capacity planning: This capacity planning involves the planning and implementation of hardware resources that will be used to accomplish a given task.
  • Share/Bookmark
uCertify.com | Our Company | Articles | Contact Us | News and Press Release | uCertify India | Entries (RSS)
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD    Cisco Certification: CCNA, CCENT    A+, Network+, Security+ Project+
Oracle Certification: OCP 11g, OCP 10g, OCA 11g, OCA 10g    CIW foundation    EC-212-32,    CISSP    Photoshop ACE CS4    Adobe Flash ACE, PMP, CAPM
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.