Viewing 15 posts - 12,361 through 12,375 (of 49,552 total)
Those suspended queries are suspended waiting for what?
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 16, 2013 at 1:31 am
Replication is not deprecated.
Technically it's not a HA solution. It can however be used for HA in some cases.
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 16, 2013 at 1:28 am
poratips (7/15/2013)
Is it virtualization is good or stand alone server hardware is good?
Virtualisation's fine, stand alone hardware's fine, depending on what you're doing
Is it 8 core/CPU is enough?
No way 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 16, 2013 at 1:27 am
After a service pack installation. This isn't a replacement for database backups (which you need to do regularly). It's as well as.
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 16, 2013 at 1:25 am
Welsh Corgi (7/15/2013)
Yes. It is a backup that can be used for PIT recovery.Am I missing something?
Yes, that you have the NORECOVERY option on the log backup. i.e. back up...
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 16, 2013 at 1:25 am
Welsh Corgi (7/15/2013)
GilaMonster (7/15/2013)
What is the exact backup command that's been run?
BACKUP LOG DataWarehouse TO DISK e= N'D:\Backup\TransactionLog\Data\DataWarehouse_backup_2013_07_15_181847_8601173.trn'
WITH NOFORMAT, NOINIT,
NAME = N'DataWarehouse_backup_2013_07_15_181847_8601173',
SKIP, REWIND, NOUNLOAD, ...
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, 2013 at 4:36 pm
What is the exact backup command that's been run?
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, 2013 at 4:03 pm
As I said earlier...
GilaMonster (7/15/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
July 15, 2013 at 10:47 am
About bloody time 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 15, 2013 at 10:34 am
Well they can't just 'go suspect'
Suspect mode requires that SQL encounters corruption during a transaction rollback or during crash recovery. Typically, because the system databases (other than MSDB) aren't changed...
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, 2013 at 9:05 am
Then the correct answer would be 'There are no other sensible ways of doing it.'
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, 2013 at 8:32 am
As I said, to fix fragmentation you have to either rebuild the index or reorganise the index.
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, 2013 at 7:12 am
If SQL cannot open and recover master and model successfully, SQL's startup process will fail. If MSDB can't be opened and recovered, SQL Agent will not be able to run.
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, 2013 at 6:52 am
Are you sure the fragmentation is the direct cause of the poor performance?
To fix fragmentation, rebuild or reorganise the index.
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, 2013 at 6:44 am
ananda.murugesan (7/15/2013)
But actucal exec.plan high seek 94% which created new index on that table...
Why are you fixated on the cost % of the index seek in the plan?
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, 2013 at 6:37 am
Viewing 15 posts - 12,361 through 12,375 (of 49,552 total)