Viewing 15 posts - 22,831 through 22,845 (of 49,552 total)
Use Database
disable trigger dbo.triggername on dbo.tablename
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 21, 2011 at 9:03 am
GilaMonster (10/21/2011)
Plans don't get corrupted.Could be parameter sniffing, could be (but probably isn't) stale statistics, could be a bunch of other related things.
It's hard-impossible to say more without seeing at...
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 21, 2011 at 8:25 am
Try taking the affected DB offline and then online (alter database ... set offline, alter database ... set online)
If that doesn't work, post any errors.
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 21, 2011 at 8:20 am
Plans don't get corrupted.
Could be parameter sniffing, could be (but probably isn't) stale statistics, could be a bunch of other related things.
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 21, 2011 at 8:06 am
You were hired as a DBA?
How much experience do you have as a DBA?
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 21, 2011 at 7:33 am
Google down?
For lots of transactions, wait. There's nothing else that can be done there (especially if the failover was uncontrolled)
For VLFs - http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.aspx
Also, what's the sizes of the mirroring redo...
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 21, 2011 at 6:16 am
Optimise your queries, tune your indexes. High CPU utilisation is most commonly from badly performing code.
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 21, 2011 at 6:11 am
Ninja's_RGR'us (10/21/2011)
What I had understood from Paul's video is that there was no difference in the log backup size hence my comment about the no difference.
There won't be a...
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 21, 2011 at 6:05 am
More details than Paul's videos? No, except maybe his training courses.
Index rebuilds are bulk operations. They are fully logged in full recovery (entire page images are logged), they can 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 21, 2011 at 5:20 am
Query for small ranges of data using the clustered index key. Lots of work, but you can avoid the corrupt portions of the tables 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 21, 2011 at 5:14 am
No. The only thing that updates stats are index rebuilds, auto stats updates and UPDATE STATISTICS. However truncate, setting the rowcount to 0, will ensure that autoupdate gets triggered 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 21, 2011 at 5:13 am
Lots of VLFs
Large tranactions to roll back.
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 21, 2011 at 5:11 am
That 'best practice' is at best vague. There's far more in consideration than just selectivity.
Selectivity is irrelevant when the index is covering. It's very important when the index is not...
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 20, 2011 at 4:40 pm
goetz.gaertner (10/20/2011)
you have the columns of this already in any Nonclustered Index. So you
don't have to include...
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 20, 2011 at 4:33 pm
Those DMVs are server-wide. There's nothing about that query that is restricted to one DB over another.
What do you mean by 'doesn't work'? Throws an error? Returns no data? Sucks...
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 20, 2011 at 12:24 pm
Viewing 15 posts - 22,831 through 22,845 (of 49,552 total)