Home » Posts tagged 'SQL 2012' (Page 3)
Tag Archives: SQL 2012
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
Cumulative Update – 8 for SQL Server 2012 Service Pack 1 Is Now Available !
The 8th cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 8 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are facing severe issues with their environment, they can plan to test CU8 in test environment & then move to Production … 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 – 10 for SQL Server 2012 RTM Is Now Available !
The 10th cumulative update release for SQL Server 2012 RTM is now available. Cumulative Update 10 contains all the hotfixes released since the initial release of SQL Server 2012 RTM. Those who are facing severe issues with their environment, they can plan to test CU10 in test environment & then move to Production after satisfactory … 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