Viewing 15 posts - 4,576 through 4,590 (of 49,552 total)
Don't use task manager to check SQL Server's memory. It lies (and I've posted this soooo many times recently)
Use perfmon, use the target and total server memory counters.
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 8, 2015 at 11:57 am
You're not going to see a difference in inserts or restores. See the article I referenced where Tony and I tested the difference between about 20 VLFs and 16000 VLFs...
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 8, 2015 at 11:55 am
Can't make specific, useful suggestions without seeing the definitions of FTcomparison and returnFlagForTemp, but in general you need to rip those cursors out, convert them and the function calls 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
October 8, 2015 at 5:27 am
The QO will chose the smallest index, so if there's a nonclustered index that's 1 byte smaller than the clustered, that'll be the one chosen. Whether it makes sense 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
October 8, 2015 at 4:30 am
You're not going to see much of a difference with a hundred or so VLFs. Try getting up to tens of thousands.
You see the effect mostly on recovery, when starting...
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 8, 2015 at 3:55 am
Sure. Run update statements to make the required data changes.
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 8, 2015 at 3:05 am
WhiteLotus (10/7/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
October 8, 2015 at 2:41 am
Can you post create table statements for all involved tables please?
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 8, 2015 at 2:37 am
Without seeing the code, impossible to give any specific suggestions.
In general, you probably need to:
Replace the cursors with set-based queries (and no, don't just replace with a while loop). This...
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 8, 2015 at 2:35 am
nm, ignore
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 7, 2015 at 8:02 am
You need SP 4 for an in-place upgrade.
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 7, 2015 at 7:22 am
Please can you get the deadlock graph and post it? Can't diagnose a deadlock on vague descriptions of processes.
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 7, 2015 at 5:01 am
Grant Fritchey (10/7/2015)
You're already capturing deadlock information in the system_health extended event session.
On 2008?
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 7, 2015 at 5:00 am
Yes. The number in brackets is the number of characters that the column can hold. NVarchar(10) can hold 10 characters, "SQL Server" is 10 characters, so it'll fit.
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 6, 2015 at 11:13 pm
Please post the deadlock graph and details of the two queries involved.
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 6, 2015 at 11:07 pm
Viewing 15 posts - 4,576 through 4,590 (of 49,552 total)