Viewing 15 posts - 11,446 through 11,460 (of 49,552 total)
Have a look at the sys.dm_os_memory* DMVs and the memory-related counters for SQL Server in perfmon.
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
October 3, 2013 at 4:17 am
Yes, unless the archive filegroup was marked read only before that 7/31 backup and remained that way.
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
October 3, 2013 at 3:55 am
If you can't change the hardware, tune the queries. Goal being to reduce as much as possible the amount of data the query needs to read.
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
October 3, 2013 at 3:11 am
I think the question would be more appropriately phrased 'any other similarities?', because other than that they can truncate the log (checkpoint in simple, log backup in other recovery models)...
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
October 3, 2013 at 2:59 am
I would imagine not, alter database usually requires an exclusive database lock.
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
October 2, 2013 at 3:41 pm
Don't shrink your log. Please read the article I referenced.
If the same database pages are getting repeatedly modified, log backups can be larger than the diffs.
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
October 2, 2013 at 3:09 pm
GilaMonster (10/2/2013)
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
October 2, 2013 at 3:07 pm
I tend to agree with Michael. File/filegroup backups make backup times faster (because you're only backing up part of the DB each time), but they massively complicate restores. If 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
October 2, 2013 at 12:21 pm
Did you read the article I referenced?
If your log is growing, there is something modifying that database. Logs won't grow without log records being added, that is changed to the...
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
October 2, 2013 at 10:28 am
Take a read through this: http://www.sqlservercentral.com/articles/Corruption/65804/
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
October 2, 2013 at 9:54 am
If that was one of my ciients' databases, I'd be scripting, exporting and recreating it. Probably someone hacked the system tables back when that was a SQL 2000 database and...
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
October 2, 2013 at 9:49 am
Sean Lange (10/2/2013)
Jeff Moden (10/2/2013)
Koen Verbeeck (10/2/2013)
On topic:http://www.sqlservercentral.com/Forums/Topic1500646-1292-1.aspx
Oh my. I hope that's not what they're teaching in "university" now. :sick:
If you have read any of the other posts by...
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
October 2, 2013 at 9:46 am
Yes it's a single point of something, but losing the witness will only remove the ability of the mirroring to automatically fail over. It'll have no other effect.
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
October 2, 2013 at 9:43 am
FROM CalenderTable LEFT OUTER JOIN TableWithOtherDatesInIt
That's the starting point. Your where clause was filtering out any nulls and essentially turning the join into an inner join.
You don't want to 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
October 2, 2013 at 7:36 am
A log file will only grow if there's activity being logged.
As for log maintenance, see http://www.sqlservercentral.com/articles/Administration/64582/
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
October 2, 2013 at 7:20 am
Viewing 15 posts - 11,446 through 11,460 (of 49,552 total)