Viewing 15 posts - 23,356 through 23,370 (of 49,552 total)
dm_tapas (9/22/2011)
Due to that ,, I got the avg. page lock/ avg. object lock is more than 95 % ... last few days.
Absolutely sure SQL's memory usage is the cause?
...
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 22, 2011 at 6:46 am
Nope.
Internally, on the page, SQL stored the variable length columns after the fixed length, but that's the internal row structure which does not correspond to the table design.
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 22, 2011 at 6:34 am
That's not a memory leak. It's perfectly normal, documented behaviour. SQL uses as much memory as it can get to cache data and plans for optimal performance
If you want 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 22, 2011 at 6:20 am
forsqlserver (9/22/2011)
The roll forward start point is now at log sequence number (LSN) 35000000119200001. Additional roll forward past LSN 35000000130100001 is required to complete the restore sequence.
That message means you...
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 22, 2011 at 5:52 am
If you query sys.databases, is the database in question listed?
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 22, 2011 at 4:19 am
Query sys.dm_exec_requests cross apply sys.dm_sql_text, filter on sessions with one of the lock waits and a relatively high wait time. That'll give you the blocked statement. Take the blocking_session_id and...
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 22, 2011 at 3:41 am
Log shipping won't cause that. Log shipping is just regular log backups and they don't affect DB activity in any way.
That read uncommitted isolation level however could very well cause...
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 22, 2011 at 3:00 am
Please post table definitions, index definitions and execution plans, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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 22, 2011 at 2:52 am
Not only is it possible, it's very likely unless the two servers are absolutely identical (SQL version, indexes, statistics, data size, data distribution)
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 22, 2011 at 2:36 am
baabhu (9/22/2011)
Create event notification in server to log the blocking.I have attached how we done in our environment to capture the deadlock using service broker. Hope this helps you.
Blocking...
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 22, 2011 at 2:35 am
Jim Murphy (9/21/2011)
And where's Gail? Is she not keeping you guys in line?
Doing the final checks and tweaks on Jonathan's book.
Keep this lot in line? How would I ever...
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 22, 2011 at 2:32 am
And if the query is auto-generated it won't be possible (except maybe with plan guides)
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 21, 2011 at 5:21 pm
Different SET options resulting in different execution plans, one good one bad. Without seeing the plans (which are gone since the stats update) near-impossible to say anything 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
September 21, 2011 at 4:46 pm
Don't encrypt passwords. You have no need to ever obtain the plain-text password. Use a one-way hash (like hashbytes) with a salt and then hash and compare passwords entered by...
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 21, 2011 at 4:45 pm
dbajunior (9/20/2011)
Some settings, such as Queue Length, specify the Warning level should be 5 * number of arrays. How do I determine that number? (I'm pretty new to this).
Disk Queue...
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 21, 2011 at 3:22 pm
Viewing 15 posts - 23,356 through 23,370 (of 49,552 total)