Viewing 15 posts - 11,821 through 11,835 (of 49,552 total)
It's a bug in Management studio
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, 2013 at 2:32 am
If you're seeing mirroring-related waits, check the latency of the line to the mirror, make sure that nothing's wrong, check write throughput on the mirror's log drive. The state will...
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, 2013 at 2:13 am
Can you post the procedure?
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, 2013 at 2:07 am
durai nagarajan (9/3/2013)
But why not they check OS Memory before accepting it?
Why should it?
How does SQL know that I'm not setting max server memory higher then going home while 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, 2013 at 1:12 am
santhosh411 (9/3/2013)
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, 2013 at 1:11 am
Why wouldn't it accept the value?
If you check books online, max server memory must be a value between 16 and 2147483647, min server memory must be a value between 0...
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, 2013 at 1:00 am
Depends which gives the expected results. The choice of the two is not a performance consideration, it's a correctness consideration.
Union - combine the two resultsets and remove duplicates.
Union all -...
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, 2013 at 12:57 am
Primary key is not decided by a query. It's part of the design process of the table. It's a column or set of columns that uniquely (with no nulls) identifies...
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, 2013 at 12:55 am
Please post table definition, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/. Tuning is seldom about removing portions of a query.
Also ditch the nolocks, unless the users know and accept...
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, 2013 at 12:53 am
Since SQL will never be able to reach 5GB (and hence the min server memory setting will never take effect), nothing different to the default setting (where max server memory...
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, 2013 at 12:49 am
iirc he also wrote a chapter in one of the MVP Deep Dives on the subject.
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, 2013 at 12:44 am
Err... the second line of my post....
As for why SQL's using the memory, because it can. Because it has not been told that it can't (via max server memory). Set...
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, 2013 at 12:41 am
Shadab Shah (9/2/2013)
So you are telling me that this missing index dmv's are useless :w00t:.
No. I didn't say they're useless. I said they're a place to start.
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, 2013 at 12:37 am
SQLRNNR (9/2/2013)
Pins and needles seeing the strike-through on your MCM in the signature.
I'll remove the strikeout in a week or two. Just making a point.
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, 2013 at 5:05 pm
No idea. Maybe. Possibly not.
Ignore fragmentation on very small indexes. It's meaningless on very small indexes (which are the ones that usually show this kind of behaviour)
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, 2013 at 5:05 pm
Viewing 15 posts - 11,821 through 11,835 (of 49,552 total)