Home » Posts tagged 'SQL 2008 R2' (Page 3)
Tag Archives: SQL 2008 R2
System Configuration Check – Without Starting SQL Server Installation
Question : Can we do system configuration check with starting SQL Server installation? One of my friend need to submit it to get installation approval. This is to ensure that no configuration issue occur at time of installation. Answer : Yes, We can do it. Step 1: Run Setup.exe Step 2 : Go to Tool … Continue reading
Database Snapshot failed due to disk space issue
Database snapshot is really a useful feature. As we know, Snapshot database file will keep increasing parallel to the DML operations on database. But if disk containing snapshot file run out of space then what will be the impact on new transactions, database & snapshot? Microsoft design snapshot in very well manner. If Snapshot failed … Continue reading
Cumulative Update – 9 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 9th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 9 contains all the hotfixes released since the initial release of SQL Server 2008 R2 SP2. Those who are facing severe issues with their environment, they can plan to test … Continue reading
DMV-15 : Pending I/O requests……..sys.dm_io_pending_io_requests
sys.dm_io_pending_io_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms188762.aspx Returns a row for each pending I/O request in SQL Server. It’s a very simple DMV used to see all pending I/O requests & there description. You can combine this DMV with DMF – sys.dm_io_virtual_file_stats to see I/O pending requests with database files. You … Continue reading
How to Check SQL Server Evaluation Version Expire Date ?
SQL Server Evaluation Edition is available free of cost. It’s a trial version & valid for limited time of period. The expiration date is always 180 days from the initial installation date. The following query will give you the expiration date of evaluation instance : SELECT @@SERVERNAME SERVERNAME, CREATE_DATE ‘INSTALALTIONDATE’, SERVERPROPERTY(‘EDITION’) ‘Version’, DATEADD(DD, 180, CREATE_DATE) … Continue reading