Viewing 15 posts - 8,701 through 8,715 (of 49,552 total)
Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others"
"No pressure to work overtime" they say. :ermm:
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 17, 2014 at 4:32 pm
Most queries don't use much memory, the buffer pool is shared. Only workspace memory grants are per query.
For overall CPU, reads, duration, take a look at this (aging) article:
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 17, 2014 at 3:57 pm
You should be able to use the snapshot agent as it's just a couple of tables, but test and 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
June 17, 2014 at 1:53 pm
kevinsql7 (6/17/2014)
Did the log file not shrink as much because the DBCC SHRINKDATABASE command is also writing to the log file?
No. The log can only be shrunk to the end...
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 17, 2014 at 1:45 pm
CREATE - once created add it to the articles published and run the snapshot agent. It *should* just snapshot the new table
DROP - remove the table from the articles published...
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 17, 2014 at 12:59 pm
Wrong forum 🙂
It's been reported and raised to the relevant people
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 17, 2014 at 12:58 pm
Andrew Kernodle (6/17/2014)
But technically, I've gotten leave time in both DBA jobs I've had so far; I've just not been allowed to use it.
That's the same as no...
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 17, 2014 at 12:35 pm
Grant Fritchey (6/17/2014)
But there are processes that you don't really want to have mess up in the middle because of a somewhat higher likelihood of corruption wouldn't you agree?
No,...
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 17, 2014 at 12:29 pm
Eirikur Eiriksson (6/17/2014)
GilaMonster (6/17/2014)
Welsh Corgi (6/17/2014)
If I were to kill the process could I corrupt the Database?
No.
There is no process in SQL that you can run or kill that 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
June 17, 2014 at 12:28 pm
These may help
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
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 17, 2014 at 12:18 pm
ggoble (6/17/2014)
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 17, 2014 at 12:17 pm
Welsh Corgi (6/17/2014)
If I were to kill the process could I corrupt the Database?
No.
There is no process in SQL that you can run or kill that will cause corruption.
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 17, 2014 at 12:08 pm
Andrew Kernodle (6/17/2014)
Beatrix Kiddo (6/17/2014)
Andrew, how do you cope with no annual leave? (If that's not too personal.)
Simple! No job I've ever held so far has allowed me 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
June 17, 2014 at 12:05 pm
Yup, any single statement. Thing is, you have to stop it before it completes, and SQL won't always process a stop request immediately so you can easily stop too late...
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 17, 2014 at 5:54 am
Interesting...
CheckDB shouldn't be trying to take locks at all. I wonder if it's failing to create the DB snapshot and resorting back to table locks. Can you check the error...
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 17, 2014 at 5:45 am
Viewing 15 posts - 8,701 through 8,715 (of 49,552 total)