Viewing 15 posts - 4,051 through 4,065 (of 49,552 total)
Probably because the new server has an index maintenance job that does ALTER INDEX REORGANIZE, whereas the old server didn't. REORGANIZE needs page locks to be enabled
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
December 9, 2015 at 9:10 am
Why don't you download a CTP now and play with 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
December 9, 2015 at 9:04 am
Cache hit ratios are useless counters. A server has to be under sever, long-term memory pressure before buffer cache hit ratio will dip.
Look for queries that run around those times...
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
December 9, 2015 at 6:43 am
BrainDonor (12/9/2015)
I have SSMS on my PC and connect to them from that. If a remote connection isn't possible then probably Powershell.
Yup, this exactly. Since you shouldn't be logging into...
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
December 9, 2015 at 5:55 am
I already did.... See the other thread you posted on.
Please in future post new questions in a new thread.
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
December 9, 2015 at 3:36 am
CheckDB doesn't check the log, so it wouldn't pick this up.
When you have some downtime:
Switch DB to simple recovery model.
Checkpoint
Shrink log to 0
Regrow log to full...
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
December 9, 2015 at 3:19 am
To get a benefit from an SSD, you need to identify what parts of the workload are IO-bound, what files are under IO pressure and move those files. As usual,...
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
December 9, 2015 at 3:05 am
Full text indexing isn't something that you just create and suddenly everything magically works better. You need to do some design work, planning, code changes, etc.
Grant said you may need...
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
December 9, 2015 at 2:00 am
mastersql (12/8/2015)
The percentage complete column is really useful.
Keep in mind that it's an estimate.
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
December 8, 2015 at 1:38 pm
https://msdn.microsoft.com/en-za/library/ms188300.aspx
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
December 8, 2015 at 4:18 am
What do you mean? Are you trying to include a computed column in a new table definition? Something else?
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
December 8, 2015 at 3:46 am
Yup, they can start as row or page, but if they start as row locks (KEY/RID), they will either stay as row locks or escalate to table/partition. Row locks can...
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
December 8, 2015 at 2:31 am
Dave Morrison (12/8/2015)
locks escalate in three steps, row, page and then table.
No they don't.
Escalation is straight to table, no matter whether the locks start as row or page. 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
December 8, 2015 at 2:16 am
GilaMonster (11/16/2015)
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
December 8, 2015 at 2:13 am
er.mayankshukla (12/8/2015)
So, is it that in Partitioned tables the insert operations do not escalate locks and keep it to RID to enable concurrency
No, it is not.
Escalation isn't guaranteed to succeed....
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
December 8, 2015 at 2:06 am
Viewing 15 posts - 4,051 through 4,065 (of 49,552 total)