InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 20:41:15 GMT20http://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspx[quote][b]YarHad (10/9/2012)[/b][hr]...I am rebuilding/reorganizing indexes and I am trying to locate the activity via server logs...[/quote]If you're reorganizing or rebuilding your indexes in a SQL Agent Job, you can examine the Job History for that job to see the details about the job: execution start time, time to execute, success or failure, and more.The rebuild operation can be minimally logged to the database log file if the database recovery model is set to either bulk-logged or simple.Fri, 12 Oct 2012 11:45:20 GMTGail Wanabeehttp://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspx[quote][b]GilaMonster (10/9/2012)[/b][hr][quote][b]Evil Kraig F (10/9/2012)[/b][hr][quote][b]YarHad (10/9/2012)[/b][hr][quote][b]GilaMonster (10/9/2012)[/b][hr]Index rebuilds don't get written into the SQL Server error log. You could add a piece to your maintenance tasks to log that a rebuild was done if you like, or run a trace or set up an extended events session.[/quote]Ok, so it doesn't get written into the sql server log. Nice to knowThank you very much!![/quote]Just to clarify, what Gail's repeated above is that the Index Rebuild WILL be written into the log file (.ldf) that's attached to the database. That's not human readable, unfortunately.[/quote]Welll....... I can read it. Mostly. :-)[/quote]I'm still not entirely convinced you're not a Turing Complete database with the amount of knowledge you inhale for fun, though... :-P I shouldn't pick on ya much for it though, I certainly benefit a lot from your knowledge. :cool:Wed, 10 Oct 2012 10:52:53 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspx[quote][b]Evil Kraig F (10/9/2012)[/b][hr][quote][b]YarHad (10/9/2012)[/b][hr][quote][b]GilaMonster (10/9/2012)[/b][hr]Index rebuilds don't get written into the SQL Server error log. You could add a piece to your maintenance tasks to log that a rebuild was done if you like, or run a trace or set up an extended events session.[/quote]Ok, so it doesn't get written into the sql server log. Nice to knowThank you very much!![/quote]Just to clarify, what Gail's repeated above is that the Index Rebuild WILL be written into the log file (.ldf) that's attached to the database. That's not human readable, unfortunately.[/quote]Welll....... I can read it. Mostly. :-)Tue, 09 Oct 2012 18:40:43 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspx[quote][b]YarHad (10/9/2012)[/b][hr][quote][b]GilaMonster (10/9/2012)[/b][hr]Index rebuilds don't get written into the SQL Server error log. You could add a piece to your maintenance tasks to log that a rebuild was done if you like, or run a trace or set up an extended events session.[/quote]Ok, so it doesn't get written into the sql server log. Nice to knowThank you very much!![/quote]Just to clarify, what Gail's repeated above is that the Index Rebuild WILL be written into the log file (.ldf) that's attached to the database. That's not human readable, unfortunately.It doesn't get into the error logs for the server, however, which is where we could actually find it. ;-)Some of the .ldf writes tend to get confused as to whether or not they're actually written there so it's really just us trying to kill some old myths and make sure they don't start up again.Tue, 09 Oct 2012 17:36:53 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspxNot into the SQL Server error log (text file).Tue, 09 Oct 2012 17:28:46 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspx[quote][b]GilaMonster (10/9/2012)[/b][hr]Index rebuilds don't get written into the SQL Server error log. You could add a piece to your maintenance tasks to log that a rebuild was done if you like, or run a trace or set up an extended events session.[/quote]Ok, so it doesn't get written into the sql server log. Nice to knowThank you very much!!Tue, 09 Oct 2012 08:50:51 GMTYarHadhttp://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspxIndex rebuilds don't get written into the SQL Server error log. You could add a piece to your maintenance tasks to log that a rebuild was done if you like, or run a trace or set up an extended events session.Tue, 09 Oct 2012 08:25:54 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspxReorgs should look something like this:[code="sql"]USE [DatabaseName]GOALTER INDEX [IndexName] ON [dbo].[TableName] REORGANIZE WITH ( LOB_COMPACTION = ON )GO[/code]Rebuilds would look something like this:[code="sql"]USE [DatabaseName]GOALTER INDEX [IndexName] ON [dbo].[TableName] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )GO[/code]The WITH section of each will vary. Check out the ALTER INDEX pages in BOL for the various options.Tue, 09 Oct 2012 08:08:31 GMTScott D. Jacobsonhttp://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspxOk, let me start again.you know when you check the sql server logs, you can see things that happened in the databasee.g alter recovery mode, database backup, database restore, sql server start up e.t.cHow can I find an entry for an index rebuild/reorgTue, 09 Oct 2012 08:01:26 GMTYarHadhttp://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspxSorry SQl server logsTue, 09 Oct 2012 07:57:15 GMTYarHadhttp://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspxWhat do you mean by 'activity log'?Tue, 09 Oct 2012 07:52:18 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspxSo How to I locate the activity. ie for example when a database is backed up, one can see the activity logged in the activity log.How come I can see the rebuild/reorg activity in the activity logTue, 09 Oct 2012 07:46:39 GMTYarHadhttp://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspxRecovery mode refers to the transaction log, which is not the same as server logs.Tue, 09 Oct 2012 07:20:46 GMTSean Pearcehttp://www.sqlservercentral.com/Forums/Topic1370380-1292-1.aspxHi All,I am rebuilding/reorganizing indexes and I am trying to locate the activity via server logsHowever I can't find it.My database is in Full recovery mode (As simple or bulk logged mode will minimally log the process) and I am not specifing for the rebuild to take place online (as this would also minimally log the process)Can someone please point me in the right direction or are all rebuilding/reorganizing processes minimally logged regardlessThanksTue, 09 Oct 2012 07:15:50 GMTYarHad