Viewing 15 posts - 4,831 through 4,845 (of 49,552 total)
Yup, and hence Test Manager and RAMMap are both lying to you. Neither considers physically allocated memory (what locked pages allows SQL to take), and hence they're both showing 24GB...
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
September 3, 2015 at 2:23 pm
Honestly, part of the problem here is that you're looking at disparate things and assuming they mean what you think they mean, when they probably don't.
I don't have time 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
September 3, 2015 at 12:50 pm
Don't guess. Diagnose and identify the exact problem. Guessing just wastes time.
Problem is by pulling the DB out of the AG, you'll have lost any information that was in AG-related...
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
September 3, 2015 at 11:35 am
Lynn Pettis (9/3/2015)
Anything to do with not wanting to write "dbo." any more?
Just saw that. :angry:
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
September 3, 2015 at 11:11 am
Prefixing objects with their schema is a good thing to do and is a recommended practice. Not doing so can cause problems with plan reuse. It's something I flag 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
September 3, 2015 at 11:10 am
Try
CONVERT(bigint, IIF(IsNumeric(CALL_ANI)=1,CALL_ANI, CAST(0 AS bigint))) AS ANI
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
September 3, 2015 at 11:03 am
Then the log backups are not the issue. The issue is that something else is preventing log reuse. Switching to simple will do exactly the same as a log 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
September 3, 2015 at 11:02 am
Precon tomorrow. Two presentations at SQL Sat on Saturday. Usergroup meeting on Tuesday. Flying to Cape Town on Friday, 1 (or maybe 2) presentations on the Saturday. Grad on 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
September 3, 2015 at 11:00 am
Per user.
It's the sameish as a web server connecting to SQL and people using the web site. The people using the site need to be licensed, not the web server.
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
September 3, 2015 at 10:55 am
Don't. Use. The. Task. Manager. To. Check. SQL. Server's. Memory!
The task manager does not show accurate values in several cases. Do not use it. Use perfmon and look at 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
September 3, 2015 at 10:51 am
http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
Switching to simple recovery will only do anything if the cause of the logs not truncating was the lack of a log backup. If that was the cause, then doing...
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
September 3, 2015 at 10:49 am
You haven't got lock escalation. If you had, it'd be a LCK_M_S at the table level, not the intent lock.
The only thing that would be blocking an intent S lock...
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
September 2, 2015 at 3:01 pm
Jeff Moden (8/28/2015)
Before you go to all that trouble, try changing "postalid" to "*" or "1" in the not exists and see what happens.
That won't do anything. The SELECT...
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
September 2, 2015 at 9:07 am
It wouldn't, though identifying cores/NUMA node might be a tad more challenging, and if the VM admin's screwed up the config, could be harder still.
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
September 2, 2015 at 8:51 am
EasyBoy (9/2/2015)
I will check with senior person if we can remove unlimited auto-growth option and set something about 400-500 MB in place of 10%.
Remove the limited autogrowth, you mean?
I would...
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
September 2, 2015 at 7:33 am
Viewing 15 posts - 4,831 through 4,845 (of 49,552 total)