Viewing 15 posts - 9,661 through 9,675 (of 49,552 total)
kshaileshbca (3/15/2014)
Fist you have to check fragmentation level
What's that got to do with memory?
add lock pages in memory
Um, no. That's not going to reduce memory usage, do you know what...
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
March 15, 2014 at 8:17 am
A rollback takes as long or longer than the operation had until the point it was cancelled. You wait, because there's nothing else you can do.
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
March 15, 2014 at 8:14 am
wolfkillj (3/14/2014)
GilaMonster (3/14/2014)
So what does it mean when I have things that I've said in people's signatures or on people's walls? :blush:
It means that I'll gladly endorse you for Pithy...
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
March 14, 2014 at 2:54 pm
The one database file per core recommendation is an outdated one for TempDB only. It's never been a recommendation for user databases and even for TempDB now it's 1/4-1/2 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
March 14, 2014 at 2:43 pm
Jeff Moden (3/13/2014)
GilaMonster (3/13/2014)
Jeff Moden (3/12/2014)
Using "Statistics TIME, IO" will also be way off if there are any non iTVF functions in the mix.
IO will be. Time, if you look...
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
March 14, 2014 at 2:34 pm
wolfkillj (3/14/2014)
wolfkillj (3/13/2014)
GilaMonster (3/11/2014)
Koen Verbeeck (3/11/2014)
Grant Fritchey (3/11/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
March 14, 2014 at 2:29 pm
rodjkidd (3/14/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
March 14, 2014 at 2:28 pm
New Born DBA (3/14/2014)
In this case let's say the DB goes down at 1:55, how do we restore it to the point in time recovery? What's the procedure?
Depends on 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
March 14, 2014 at 1:10 pm
hada79 (3/14/2014)
I am guessing it is a matter of time before the application (Citrix provisioning server) accesses the bad page and freaks out, but will the problem get worse?
Corruption won't...
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
March 14, 2014 at 12:58 pm
Bijoy.Kaiprath (3/14/2014)
try executing dbcc with allow data loss
NO! NO! NO! (not that it will do a damned thing in this case)
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
March 14, 2014 at 12:53 pm
Corrupt page in a system table. This is not good news. There may well be more corruption, we just don't know.
Can you restore your latest backup somewhere else and run...
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
March 14, 2014 at 7:52 am
Eric M Russell (3/14/2014)
Well, if it took only 1/2 second to delete 20 million rows, then he's lucky. That's not typical; almost to the point of disbelief.
TRUNCATE TABLE
It doesn't process...
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
March 14, 2014 at 7:48 am
Cannot be done.
Filegroups cannot move from one database to another.
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
March 14, 2014 at 5:39 am
Trigger/CDC is indeed a good idea. Write a script to auto-create the triggers on all the necessary tables, not that hard to do.
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
March 14, 2014 at 5:38 am
Siberian Khatru (3/14/2014)
For me, the keys were not needing to worry about getting all of the rows back, plus the minimal logging aspect.
Well....
Both delete and truncate can be rolled...
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
March 14, 2014 at 5:18 am
Viewing 15 posts - 9,661 through 9,675 (of 49,552 total)