Viewing 15 posts - 37,621 through 37,635 (of 49,552 total)
Mel, can you try rebuilding that index, see if it makes a difference.
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
July 15, 2009 at 8:09 am
I didn't mean on your production server. Do it on a dev/test machine. Do it on a local installation of SQL if you have one.
There are standard command that are...
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
July 15, 2009 at 7:58 am
SELECT FROM SomeTable
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
July 15, 2009 at 7:48 am
Oh this is fun....
Got back from shopping, booted my computer and SQL wouldn't start. Checked the error log.
The log scan number (47:112:1) passed to log scan in database 'model' 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
July 15, 2009 at 7:47 am
Lowell (7/15/2009)
there's a lot of inner joins...which part do you weant to change into a subquery?
and why?
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
July 15, 2009 at 7:44 am
I'm not normally a fan of hints, but what happens if you force that index?
SELECT *
FROM dbo.EmailRecipients er WITH (INDEX= SSC_SentDate)
INNER JOIN Emails e ON er.EmailID = e.EmailID
WHERE er.SentDate 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
July 15, 2009 at 7:40 am
Why don't you use profiler? Start a trace and then run the maint plan jobs. The trace will show you exactly what they're doing.
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
July 15, 2009 at 7:38 am
Do you have any transactional replication configured?
Can you run DBCC OPENTRAN and post the results?
The distribution DB doesn't appear to have a problem with the log, just AX30_SP6_LIVE
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
July 15, 2009 at 7:27 am
Krasavita (7/15/2009)
How, do you know that?
How do I know what?
The database integrity task is a DBCC CheckDB, so it will detect any torn pages, among other corruptions if present.
I...
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
July 15, 2009 at 7:16 am
Jeff Moden (7/15/2009)
GilaMonster (7/15/2009)
Jeff Moden (7/14/2009)
Something else is going on as well. Look at the difference in durations on your machine compared to mine.
Look at the difference...
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
July 15, 2009 at 7:12 am
susan.susan28 (7/15/2009)
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
July 15, 2009 at 3:45 am
Asynchronous mirroring is only available on Enterprise edition. So on Standard your only option is synchronous with witness or synchronous without witness.
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
July 15, 2009 at 3:18 am
Mel Harbour (7/15/2009)
Note that I've adjusted the forum setup to avoid having to zip up these sqlplans.
Excellent. Thank you for that.
I'll look over this and suggest any possible...
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
July 15, 2009 at 3:01 am
You cannot do auto-failover without a witness server.
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
July 15, 2009 at 2:58 am
susan.susan28 (7/15/2009)
I am trying to setup database mirroring.Mirroring started and manual failover is possible.but when i shutdown the principal server ,mirror server is not changing to principal.
Which mode do you...
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
July 15, 2009 at 2:33 am
Viewing 15 posts - 37,621 through 37,635 (of 49,552 total)