Viewing 15 posts - 14,731 through 14,745 (of 19,560 total)
Grant Fritchey (4/19/2010)
Trying to transfer a backup across the network in real time can cause serious issues.
Agreed - network delays can increase backup times as well as failures.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 19, 2010 at 9:44 am
Well, there we have it. Thanks for pointing it all out Stefan and Jeff for testing.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 18, 2010 at 8:23 pm
Stefan_G (4/18/2010)
I used a triple cross join to create the results. I didn't post that query back when I did my testing. My recovery model was simple.
Well, on my machine...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 18, 2010 at 6:45 pm
Stefan_G (4/18/2010)
What is your recovery model ?
I have a sample of what I ran here[/url].
I used a triple cross join to create the results. I didn't post that query...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 18, 2010 at 5:01 pm
Matt Miller (#4) (4/18/2010)
Steve Jones - Editor (4/18/2010)
Grant Fritchey (4/18/2010)
lmu92 (4/18/2010)
Is Google down?
I usually is... or maybe all those millions I pay for exclusive rights to use it is...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 18, 2010 at 1:13 pm
Stefan_G (4/18/2010)
Matt Miller (#4) (4/18/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 18, 2010 at 1:07 pm
Tom.Thomson (4/17/2010)
CirquedeSQLeil (4/17/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 17, 2010 at 11:41 am
One more note on sp-who2, note how little it has changed when SQL server has changed so much.
6.5 version used sysprocesses as well.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 17, 2010 at 10:34 am
Tom.Thomson (4/17/2010)
CirquedeSQLeil (4/16/2010)
That proc is a real piece of work - compare it some day to sql 2008.
There is very little difference - cosmetic bits (changes of captitalisation, "Exec" instead...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 17, 2010 at 10:31 am
pshaship (4/17/2010)
Are you guys do the Full/Diff/log backups to local server or backup to a Network Share?
If you backup local to the server, then if the server goes...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 17, 2010 at 8:57 am
Good luck.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 9:45 pm
Thanks for sharing that experience and resolution with us Perry.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 8:40 pm
Your assumptions are correct.
Scenario 1 You would restore full backup and then the Thursday differential (7am). Since you only do tran logs twice a day - you would lose...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 8:19 pm
Jack Corbett (4/16/2010)
Steve Jones - Editor (4/16/2010)
What do you know. I'm surprised it was there back then. Wonder if it was in 60
Did 6.0 come out before or after the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 7:50 pm
Steve Jones - Editor (4/16/2010)
What do you know. I'm surprised it was there back then. Wonder if it was in 60
I don't think so. I think 6.0 is too...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 16, 2010 at 7:45 pm
Viewing 15 posts - 14,731 through 14,745 (of 19,560 total)