Viewing 15 posts - 7,261 through 7,275 (of 49,552 total)
mario17 (11/18/2014)
Thanks, DeWayneThis works !!!!
Mario
It's also potentially left the database transactionally inconsistent and maybe even structurally inconsistent.
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
November 19, 2014 at 4:40 am
DBA_AUS (11/18/2014)
sys.databases ->log_reuse_wait_desc LOG_BACKUP
The log is not getting cleared because there's a log backup needed.
DBCC SQLPERF(LOGSPACE) 0.017 % used
However the log is almost entirely empty and is available...
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
November 19, 2014 at 4:37 am
Can you post the query, execution plan and statistics IO/TIME output?
How many rows is the query returning?
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
November 19, 2014 at 4:33 am
Innerise (11/18/2014)
So, my question is: Why is SERIALIZABLE being used for these transactions? What other factors would cause a transaction to run SERIALIZABLE?
A SET TRANSACTION ISOLATION LEVEL statement or 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
November 18, 2014 at 12:10 pm
Stefan Krzywicki (11/18/2014)
Why run a credit check on a DBA?
Sysadmin access to a server that processes millions of dollars of transactions a day... (what I had when I worked at...
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
November 18, 2014 at 7:31 am
http://ora-12154.ora-code.com/
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
November 18, 2014 at 6:12 am
SQL Galaxy (11/18/2014)
What witness type do you intend to use for your Windows Server failover Cluster?It means FULL RECOVERY MODE. For data synchronize both database, but I am not sure.
Witness...
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
November 18, 2014 at 5:59 am
I causally track countries visited (not something which changes fast), and books read per year (well behind on updating that). Not much else.
Countries visited so far: 12 (including one I...
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
November 18, 2014 at 5:37 am
Urgh.
No, I don't think the trace flag would help. Both automatic and user stats updates run implicitly in read uncommitted, they don't take any locks other than schema stability.
Gut feel,...
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
November 18, 2014 at 5:29 am
ksatpute123 (11/18/2014)
Here is the MSDN reference:
That's not an MSDN reference, that's a forum, it's no more or less reliable than any other forum. MSDN reference would be one 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
November 18, 2014 at 5:22 am
Update stats doesn't normally take any locks at all. It runs read uncommitted. It could be that something earlier in that session started a transaction and took the lock 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
November 18, 2014 at 4:50 am
Database server. Web servers typically aren't very CPU intensive, and if they become a bottleneck you can add more web servers and a load balancer. SQL however doesn't scale out...
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
November 18, 2014 at 2:22 am
and the table definition please.
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
November 18, 2014 at 1:43 am
Lynn Pettis (11/17/2014)
Even in single table queries I recommend using table aliases in the FROM clause and using that alias on the columns in the select list.
I would 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
November 18, 2014 at 1:36 am
Horizontal partitioning is just having multiple tables each storing part of the data with a view 'merging' them.
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
November 18, 2014 at 1:26 am
Viewing 15 posts - 7,261 through 7,275 (of 49,552 total)