Viewing 15 posts - 12,751 through 12,765 (of 49,552 total)
When the connection that ran the SET closes.
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
June 14, 2013 at 8:34 am
If you are running under serialisable isolation, all locks are held until the end of the transaction (and there will be a lot of locks). Hints go on queries, not...
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
June 14, 2013 at 8:20 am
dwilliscp (6/14/2013)
1) the example shows a set... begin.. comit. So once the commit is done the set command ends?
No, it's a session-level setting. It persists til you set otherwise or...
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
June 14, 2013 at 8:14 am
m.rajesh.uk (6/14/2013)
Gail you are talking about SQL 2014 .. does it released or what...
Google not working?
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
June 14, 2013 at 7:38 am
PaulB-TheOneAndOnly (6/14/2013)
No SQL Server 4.2? 6.0? 6.5? 7? on the poll? that's discrimination! 😛
No SQL Server 2014 either. 🙁
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
June 14, 2013 at 7:19 am
SET TRANSACTION ISOLATION LEVEL is used to set one of the 5 isolation levels:
READ UNCOMMITTED
READ COMMITTED
REPEATABLE READ
SERIALIZABLE
SNAPSHOT
The syntax is described at http://msdn.microsoft.com/en-us/library/ms173763.aspx
What you listed there are locking hints which go...
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
June 14, 2013 at 7:12 am
Please post table definitions, view definitions, index definitions and execution plan 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
June 14, 2013 at 7:12 am
sqldkay (6/14/2013)
But then my next Q; What is considered normal and abnormal?
Normal = normal for your system
Abnormal = not normal for your system.
If a query runs normally 2 minutes 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
June 14, 2013 at 6:30 am
http://www.sqlskills.com/blogs/paul/more-businesses-than-you-think-are-still-using-sql-server-2000/
http://www.sqlskills.com/blogs/paul/more-businesses-than-you-think-are-on-the-cutting-edge/
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
June 14, 2013 at 6:28 am
SQLSACT (6/14/2013)
A bit off topic but I stay away from using BCHR as a performance metric - It's extremely unreliable.
It's not that it's unreliable, it's that it can have...
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
June 14, 2013 at 6:24 am
Service pack, no, probably not. Is this a 32-bit instance?
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
June 14, 2013 at 6:21 am
There's no magic threshold where below that it's fine and above that it's bad. There's only normal for your system and abnormal for your system.
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
June 14, 2013 at 6:14 am
Above post edited heavily, take another read through it.
One more thing, as I mentioned I enabled AWE, how much time it took to take in effect ? According to my...
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
June 14, 2013 at 6:01 am
Investigate the queries running against the instance. Identify why they're reading so much data
Edit: Sorry, originally read that as plan cache hit ratio, ignore what was here before...
Low buffer...
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
June 14, 2013 at 5:40 am
The statistics are associated with the index (they have the same name). The only way you can drop those is to drop the index, to recreate the stats, you 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
June 14, 2013 at 2:48 am
Viewing 15 posts - 12,751 through 12,765 (of 49,552 total)