Viewing 15 posts - 45,031 through 45,045 (of 49,552 total)
rbarryyoung (8/14/2008)
Now, now, be nice to the OP, Gail. 😀
I thought I was being nice 😉
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 2:31 pm
Jeff Moden (8/14/2008)
Aw crap! They've scheduled a job for every blood Log Reader Agent!!! I'm going to need to disable those buggers, too, huh?
It should, if I recall correctly,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 2:19 pm
Jeff Moden (8/14/2008)
Aw crap! They've scheduled a job for every blood Log Reader Agent!!! I'm going to need to disable those buggers, too, huh?
That's done by default when replication...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 2:14 pm
Jeff Moden (8/14/2008)
79 not including the MS-4... appears that they have created 1 Log Reader Agent for every customer database... two of which are active constantly... the two each...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 2:12 pm
I think I haven't explained clear enough.
fn_trace_getinfo shows you the active traces that SQL knows about. It just shows traceID, status (stopped, paused, running) and file location that the trace...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 2:10 pm
GSquared (8/14/2008)
Nope. Didn't know about that option. MS Tech Support apparently didn't either
LOL.
The same file needs to be changes when running SSIS on a cluster. SSIS isn't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 2:06 pm
Pretty much, although you can interrogate SQL as to the traces that are running.
select * from fn_trace_getinfo(0)
Get profiler to generate the trace creation code for you. It's easier than...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 1:55 pm
Jeff Moden (8/14/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 1:52 pm
David Branscome (8/14/2008)
DBCC UpdateUsage shrink file sp_updatestats Index RebuildImplementing these maintenance options will improve performance.
The shrink file certainly won't.
The update stats is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 1:46 pm
Server-side trace is only to a file. Tracing to a table isn't recommended even from profiler GUI because it has the highest impact on the traced server of all of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 1:40 pm
KATHLEEN Y ZHANG (8/14/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 1:13 pm
Missing indexes is a suggestion, nothing more. The entries in there are created by the query optimiser as it optimises a single query. They may be correct, they may be...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 12:44 pm
My gut feel is that this database is unrepairable.
There's corruption in one of the system tables (syscomments) and that kind of damage CheckDB is not allowed to repair. In...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 12:34 pm
Thanks.
Was there another line at the bottome, something like "minimum level to repair this error is..."?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 12:08 pm
Ok, clarification time. The first check going to Master was true for 2000 and below. In 2005, it's a little more complex, but the same general idea.
When you execute...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 11:53 am
Viewing 15 posts - 45,031 through 45,045 (of 49,552 total)