Viewing 15 posts - 22,801 through 22,815 (of 49,552 total)
SQL authentication.
You don't have a domain that both machines are part of, hence you can't use windows authentication
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:50 pm
george sibbald (10/21/2011)
GilaMonster (10/21/2011)
Well, not task manager if you're using locked pages or AWE.
locked pages?. I decided not to complicate matters with those cans of worms as the OP states...
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:43 pm
By default, yes, but only by default.
Oh, and if count used the unique clustered index instead of a nonclustered index it would have worse performance. Count(*) will use the smallest...
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:42 pm
http://sqlinthewild.co.za/index.php/2009/04/14/on-counts/
p.s. Primary key != Clustered 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
October 21, 2011 at 5:00 pm
george sibbald (10/21/2011)
alexander.suprun (10/21/2011)
george sibbald (10/21/2011)
a max memory setting of 118GB is the buffer pool only, other SQL caches will add to that.george, where did you get this?
experience, lots of...
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 4:42 pm
george sibbald (10/21/2011)
The vendor may be thinking of a limitation in SQL2000 which was removed from SQL2005 on.
Yeah, but that just made the log backup wait until the full completed....
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 4:41 pm
Views are nothing more than saved select statements. They have no indexes on them (unless you explicitly index they view, but that's a whole nother story).
The following two are...
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 3:55 pm
alexander.suprun (10/21/2011)
george sibbald (10/21/2011)
a max memory setting of 118GB is the buffer pool only, other SQL caches will add to that.george, where did you get this?
Should be in the docs,...
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 3:47 pm
I just got word from the ultimate authority of all things storage engine. The combination of CXPacket and SOS Scheduler along with the Access Method latch types indicates you're 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
October 21, 2011 at 3:18 pm
Rather than knee-jerk reducing parallelism maxdop, I'd look at the queries running in parallel and see what else they're waiting for and see if they can be optimised.
I don't know...
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 3:10 pm
SQLTrace and BrokerTask are system waits, they should be ignored.
That high latch wait worries me. Can you query sys.dm_os_latch_stats and see what the top latch wait types are? Other than...
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 2:18 pm
What's the exact version?
What wait types are you seeing?
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 1:51 pm
Depends on budget, expected load, operational policies, deprecation cycle, etc.
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 1:50 pm
And if you can't/won't buy a second licence, you need to disable that processor in the BIOS so that windows can't see it. Setting affinity is not enough.
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 1:36 pm
nawillia (10/21/2011)
Thanks Gail (another honor)I think I got it. I can't do a diff If I don't have the full that it was created from.
Oh you can take 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 1:27 pm
Viewing 15 posts - 22,801 through 22,815 (of 49,552 total)