Thursday, May 28, 2009

Event ID: 17896

Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17896
Description:

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







Check the Links Below;
http://blogs.msdn.com/psssql/archive/2006/11/27/sql-server-2005-sp2-will-introduce-new-messages-to-the-error-log-related-to-timing-activities.aspx



http://support.microsoft.com/default.aspx?scid=kb;en-us;931279




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


Read more...

Wednesday, May 27, 2009

Get Missing indexes on your Database(s)

Execute the command below;


SELECT DB_NAME(database_id) AS [DATABASE],
Equality_Columns, Inequality_Columns,
Included_Columns, STATEMENT
FROM sys.dm_db_missing_index_details
ORDER BY 1

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

Read more...

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.


Read more...

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






Read more...

Wednesday, May 20, 2009

SQL Server System Statistical Functions

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

Usage:



Example : (Get SQL Server I/O)





Read more...

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.






Read more...

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);
GO
Read more...

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.
Read more...

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 4.6.16.0 To Avoid Message "HP Virtual Bus Device Installation Requires a Newer Version. Version 4.6.16.0 is Required."

Check the Link Below;

http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?objectID=c01684544&dimid=1002159936&dicid=alr_apr09&jumpid=em_alerts/us/apr09/all/xbu/emailsubid/mrm/mcc/loc/rbu_category/alerts

Read more...

Thursday, May 7, 2009

SQL Server Detailed Memory Usage Information.

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





Check http://support.microsoft.com/kb/907877 for meanings

Read more...

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


Read more...

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.
Read more...

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.

Read more...

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 ittips@tricks.com to test@exchange2007.net between dates releated. (First 50 Result)

[PS] C:\>Get-MessageTrackingLog -Server SV2008 -EventID SEND -Sender ittips@tricks.com -Recipients test@exchange2007.net -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


Read more...

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!

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

Read more...

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
Read more...

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
http://searchwindowsserver.techtarget.com/tip/0,289483,sid68_gci1022111,00.html
Read more...
 
span.fullpost {display:none;}