Viewing 15 posts - 14,131 through 14,145 (of 49,552 total)
vinu512 (2/27/2013)
Something that helped you in learning about this when you started.......would be great.
I learnt mostly by write query, run query, analyse exec plan.
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
February 27, 2013 at 1:52 am
aviadavi (2/27/2013)
I see. well, I'm running it with read uncommitted isolation level. as i don't care few updates will not be performed exactly as i plan.
Read uncommitted (and nolock)...
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
February 27, 2013 at 1:52 am
Query sys.dm_exec_connections for that session_id
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
February 27, 2013 at 1:22 am
Never use task manager to check SQL's memory as it will display incorrect values if you have locked pages enabled (Task manager limitation)
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
February 27, 2013 at 1:21 am
How are you seeing the working set? Let me guess, task manager?
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
February 27, 2013 at 1:12 am
It's not using large pages, don't worry about that. Without traceflag 834 SQL won't use large pages, it enables the extensions, but that's all.
http://blogs.msdn.com/b/psssql/archive/2009/06/05/sql-server-and-large-pages-explained.aspx <- explained there why you see...
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
February 27, 2013 at 12:59 am
aviadavi (2/27/2013)
if I will remove the hints, SQL will make up on his own.. and will lock pages/tables as well (this i want to avoid)
Correct, it will. This is 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
February 27, 2013 at 12:40 am
In this case it's simply the smallest index that can be used to satisfy the query.
Selection has to do with which index can filter the largest number of the where...
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
February 27, 2013 at 12:27 am
Parameter sniffing, or lack thereof: http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
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
February 27, 2013 at 12:04 am
Welsh Corgi (2/26/2013)
I have had to restart the SQL Server Service, Set the Database OFFLINE and try to bring it back ONLINE and and force it to recover.
Just a restart...
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
February 27, 2013 at 12:03 am
I suggest you reconsider those queries. 🙂 While it shows all the queries currently in cache, not all plans are cached and not all plans will stay in cache.
Try something...
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
February 26, 2013 at 1:27 pm
david.alcock (2/26/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
February 26, 2013 at 9:39 am
You're probably getting escalation because of the rowlock hint.
Without the hint, SQL takes locks at whatever granularity it thinks best and escalates to table locks at a specific threshold
With 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
February 26, 2013 at 9:26 am
You could call the transaction log file readme.txt if you wanted. SQL doesn't care what the name or extension of the file is in any way.
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
February 26, 2013 at 9:15 am
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-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
February 26, 2013 at 8:40 am
Viewing 15 posts - 14,131 through 14,145 (of 49,552 total)