[MS SQL Server] setup SQL alert notify DBA about windows event log error |
- setup SQL alert notify DBA about windows event log error
- Moving LUNS
- CDC and LSNs
- Reorganize index online option
| setup SQL alert notify DBA about windows event log error Posted: 01 Mar 2013 02:56 AM PST Is there a simpler way to setup SQL alert in SSMS to notify DBA when an error log is written to windows event log.For example if the event type is an Error, or I know the event ID, can I set up the alert in SSMS?Thanks |
| Posted: 01 Mar 2013 01:03 AM PST We are planning to move LUNS from one server to other server. Do we need to detach the databases before moving the LUNS ? We have this tested without detaching the databases and it worked. But somewhere i am not comfortable to do this process on production server. Which is the best way to do it? We will be taking the disk snapshots before moving the drives after taking the sql server offline. |
| Posted: 28 Feb 2013 10:24 PM PST Hi peeps,bit of a departure from my norm I am looking at using CDC from source systems to populate a data warehouse. Currently I am looking at one SQL Server 2008 Database with circa 20 tables. We may add other instances of SQL Server at a later date.Are the Log Sequence numbers totally unique so if I want to move my changed data with LSN's between 0x00000001 and 0x00000100 then all i have to do is access all 20 Table value functions and each time I pass the same two LSN'sor are the LSN's specific to the capture instance ? I am guessing they are unique for the database where CDC is enabled?Many thanks.EPS are there any pitfalls wityh this apporach to loading a data warehouse? Planning to use net changes in the settings to assist getting the data in quickly. |
| Reorganize index online option Posted: 28 Feb 2013 10:25 AM PST Does Reorganizing index with online option causes high disk I/O...I noticed users are getting timeouts after running reorganizing index command for 2 hrs?? |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment