Thursday, May 28, 2009

Event ID: 17896

Event Type: Information
Event Category: (2)
Event ID: 17896

The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.

Check the Links Below;;en-us;931279

CPU numberStatements to enable processor affinity
02 CPUsexec sp_configure 'affinity mask', 0x00000003
04 CPUsexec sp_configure 'affinity mask', 0x0000000F
08 CPUsexec sp_configure 'affinity mask', 0x000000FF
16 CPUsexec sp_configure 'affinity mask', 0x0000FFFF
32 CPUsexec sp_configure 'affinity mask', 0xFFFFFFFF


Wednesday, May 27, 2009

Get Missing indexes on your Database(s)

Execute the command below;

Equality_Columns, Inequality_Columns,
Included_Columns, STATEMENT
FROM sys.dm_db_missing_index_details

where DATABASE is your DB Name where missing index(es) found.
equality_columns index is required on these columns
inequality_columns is list of columns that are used for inequality comparison and index is required on these.
included_columns is list of columns that are used in query for other than comparison and covering index on these is suggested.
Statement is name of table along with column where index is missing


SQL Server 2005 recovery Models

The recovery model of database determines the type of database transactions are logged and the degree of concern that provided to data loss in case of any failure.

Full Recovery Model of SQL Server 2005

The full recovery model does the most extensive logging and allows the database to be recovered to the point of failure. Full recovery model presents the highest protection against data loss. You should always configure all production databases to use full recovery.

Bulk-logged Recovery Model of SQL Server 2005

The bulk-logged recovery model fully logs transactions but mostly bulk operations, such as bulk loads, Select statements. Bulk-logged recovery model allows the database to be recovered to the end of a transaction log backup only when the log backup contains bulk changes. Recovery to the point of failure is not supported.

Simple Recovery Model of SQL Server 2005

Simple recovery model logs most transactions, logging only the information required to ensure database consistency after a system crash or after restoring a database backup. With simple recovery model the database can be recovered only to the most recent backup. This recovery model has the should not be used where data loss in the event of a crash cannot be tolerated.


View SQL Server Error log's detail by SQL Commands

Execute the command below to get error logs Archive number.

exec sp_enumerrorlogs

Then execute ;

exec sp_readerrorlog archivenumber


Wednesday, May 20, 2009

SQL Server System Statistical Functions

Number of millionths of a second in a timer tick.
The number of connections or attempted connections.
Timer ticks that the CPU has been working for SQL Server.
Time in timer ticks that SQL Server has been idle.
Timer ticks that SQL Server has spent performing I/O operations.
Number of network packet errors that have occurred.
Number of packets read from the network.
Number of packets written to the network.
Number of read/write errors during I/O operations.
Number of disk reads.
Number of disk writes.


Example : (Get SQL Server I/O)


Tuesday, May 12, 2009

Check if index(es) used in your Query.

Open New Query and write your query. Before executing your query press CTRL + L see estimated execution for your query. You can mouse over each node in the execution plan to get more information about that step, such as the type of operation that node represents, the number of rows affected, and a breakdown of the costs associated with that step.


Monday, May 11, 2009

Check if Trace is running on your SQL Server

Execute the code below on SQL Management Studio check if trace is running on SQL server.

SELECT * FROM fn_trace_getinfo(default);

Saturday, May 9, 2009

HP NC373i Disappears after Installing HP PSP Version 8.x

If your NIC Card (NC373i) has disappeared on HP BL460c server after applying PSP 8.x Pack follow the steps below to bring it back.

To resolve this issue, delete the wdf01000.sys from c:\windows\system32\drivers\ , and then re-run the HP PSP package.

Blue Screen Error 0x0000007E (0x00000005, 0x80888D615, 0xF7906C08, 0xF7906904) on HP Servers

If you are getting Blue Screen Error 0x0000007E (0x00000005, 0x80888D615, 0xF7906C08, 0xF7906904) on HP BL460c while trying to shutdown your HP server (BL,DL series ) read and apply the steps below;

Cause : You probably have installed the PSP 7.80 nic drivers (v3.0.5).

Solution : You should rollback your driver to previous version or apply the latest version of your Nic drivers.

I have applied the CP008415.exe pack from PSP 8.00 and the problem has gone away now.

If your are trying Nic drivers coming with PSP 8.20 , you could experience the problem;

Notice: (Revision) HP NC-Series Broadcom 1GbE Multifunction Driver for Windows Server - First Update to Version To Avoid Message "HP Virtual Bus Device Installation Requires a Newer Version. Version is Required."

Check the Link Below;


Thursday, May 7, 2009

SQL Server Detailed Memory Usage Information.

You can use DBCC Memorystatus command to view detailed memory information.

Check for meanings


Wednesday, May 6, 2009

Enable Network Connection for MSDE

By default remote connecion to MSDE engine is disabled. You should enable network connections on MSDE to connect remotely.

Follow the steps below;
1) Start --> Run --> svrnetcn (This command Launchs SQL Server Network utility)

Choose TCP/IP connections click --> Enable

Click Apply -> OK

And Restart SQL Server service.

MSDE starts to listen requests from TCP 1433


Monday, May 4, 2009

View MAC Address(es) and IP Address of devices connected to Cisco Router

Execute the show arp command and get the MAC and IP address of devices connected to Cisco Router.

CPU(s) operating at reduced performance level due to a low power cap

You should disable power capping or set it to a value which is greater then the current in the iLO2.

Open ILO2 Choose Power Management TAB.

If power capping feature is not available;

install latest version of Power Management Module.


Message Tracking in Exchange 2007

By default in Exchange 2007 , message tracking system is enabled. Youcan use message message tracking logs for mail flow analysis as well as troubleshooting .

You can get message tracking system settings by using Get-TransportServer for Edge and Hub transport roles and the Get-MailboxServer for Mailbox server roles.

You can modify the message tracking settings by using the Set-TransportServer and Set-MailboxServer

Using these commands above you can ;

Enable or disable message tracking system (Enabled by default)
Enable or disable logging of message subject lines (Enabled by default)

Set the maximum size of log files (10MB by default)
Set the maximum size of the log file directory (250MB by default)
Change the path of the log file (‘C:\Program Files\Microsoft\Exchange Server\TransportRoles\Logs\MessageTracking’ by default)

Set the maximum age of message tracking log files (30 days by default)

Example Command

Set Maximum Directory size 1 GB maximum log file age 40 days

C:\>[PS] C:\Users\Administrator\Desktop>Set-TransportServer SV2008 -MessageTrackingLogMaxDirectorySize 1GB -MessageTrackingLogMaxAge 40.00:00:00[PS]

Searching Message Tracking Logs

Message sent from to between dates releated. (First 50 Result)

[PS] C:\>Get-MessageTrackingLog -Server SV2008 -EventID SEND -Sender -Recipients -Start 1/1/2009 -End 2/4/2009 –ResultSize 50

Search By Subject

$hubs Get-MessageTrackingLog -MessageSubject "Production" -Start "1/01/2009 00:00:00" -End "1/04/2009 23:59:59


The properties on 'user name' have invalid data Error on Exchange 2007

If you get The properties on ''username" have invalid data. If you click OK, default value will be used instead and will be saved if you do not change them before hitting Apply or OK on the property page. If you click cancel, the object will be displayed read-only and corrupted values will be retained.The following values have invalid data: Database error on Exchange 2007 try the steps below.

1)Remove the users from within Exchange Server and Reboot Server,
2)Add users again and assigen them to the primary mail database

or check!


Saturday, May 2, 2009

Terminal Services Black Screen RDP Session

Solution Offer.
Cause to this situation can be MTU settings.

Try the following Steps Below.

1. Start > Run > Regedit
2. Navigate to HKLM \ System \ Current Control Set \ Services \ TCPIP\ Parameters
3. In the right hand pane, Right Click > New > DWORD
4. Call it EnablePMTUBHDetect set its hex value to 1
5. Reboot

Expired Credentials. Windows needs your current credentials to ensure network connectivity.

If you get the warning "Expired Credentials. Windows needs your current credentials to ensure network connectivity. Please lock this computer then unlock it using your most recent password or smart card." after logging to your computer .

Follow these steps below,

1) Check if your computer system time is matched +/- 5 minutes to your DC's time.
2)Try Use "net use * /d" command to delete all mapping drives. Then use "net use \\servername password /u:domainname\username" to cache the credentials. Relogon
3)Check the link,289483,sid68_gci1022111,00.html
span.fullpost {display:none;}