Viewing 15 posts - 17,356 through 17,370 (of 49,552 total)
Gazareth (7/30/2012)
You can also check the values from the performance counters:
select *
from sys.dm_os_performance_counters
where object_name = 'SQLServer:Databases'
and counter_name in ('Percent Log Used', 'Log File(s) Size (KB)')
That's actually...
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 30, 2012 at 4:19 am
That works. Maybe every 5 min all day long.
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 30, 2012 at 3:22 am
Step 6: Grow your log back out to a sensible size for the operations needed.
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 30, 2012 at 2:31 am
Rob Reid-246754 (7/30/2012)
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 30, 2012 at 2:30 am
Your index is not covering and you've tested with an incredibly small number of rows.
The unique index tells the optimiser that it will do one and only one lookup...
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 30, 2012 at 2:19 am
Books Online: Transaction Isolation Level
Be sure to read up on the downsides of it too.
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 30, 2012 at 2:14 am
jitendra.padhiyar (7/30/2012)
And If we have multiple DB to...
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 30, 2012 at 2:12 am
L' Eomot Inversé (7/29/2012)
I trust you responded appropriately.
Absolutely. Shift-delete
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 29, 2012 at 4:52 pm
Kwisatz78 (7/29/2012)
GilaMonster (7/29/2012)
The other thing is that the apps used share multiple databases.
Yeah, that's a pain with mirroring. It's a database-level HA solution. So if app requires multiple DBs 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
July 29, 2012 at 4:02 pm
CASE has to be part of a select statement. For conditionals outside selects, use IF.
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 29, 2012 at 1:50 pm
If the principal and mirror are in the same data centre and the entire data centre goes offline then the mirror has to be brought up manually because it does...
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 29, 2012 at 11:54 am
No, he said they can probably live with some manual intervention in certain scenarios, not that it's OK if manual intervention is required each and every time and that data...
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 29, 2012 at 11:38 am
Sachin Nandanwar (7/29/2012)
But if safety is OFF then any problem on the remote data center would not affect the principal as such.
The OP states that he wants automatic failover. That...
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 29, 2012 at 11:17 am
Was the database in full recovery model?
Do you have log backups since that last full backup?
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 29, 2012 at 7:00 am
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Also this - Managing Transaction Logs[/url]
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 29, 2012 at 2:55 am
Viewing 15 posts - 17,356 through 17,370 (of 49,552 total)