Viewing 15 posts - 16,141 through 16,155 (of 19,560 total)
Paul White NZ (3/20/2010)
...nolock is a free lunch.
Again, I blame the name.
All new DBAs 'know' that blocking and deadlocking are bad (:doze:). Blocks and deadlocks are caused by locks....
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
March 20, 2010 at 11:54 am
Is the mdf still large? By the end of your post it sounded like the backups had reduced back to normal.
Has somebody been reindexing?
Has somebody been creating copies...
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
March 20, 2010 at 10:01 am
petertrast (3/20/2010)
I gave it to her without the SQL code and she did a standard alphabet/number decode... I am going to try...
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
March 20, 2010 at 9:44 am
Tom.Thomson (2/8/2010)
GSquared (12/21/2009)
I had to decipher the code based on the usual methodology. I haven't seen the Frosty the Snowman movie since the 70s.
I did the same...
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
March 20, 2010 at 9:42 am
petertrast (3/20/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
March 20, 2010 at 9:36 am
What does the transaction log for the database look like?
How big?
What is the autogrowth on it?
How many vlfs are in it?
Compare the t-log for both tempdb and the user database...
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
March 20, 2010 at 9:28 am
Since you mention DMVs, you could start by looking for Glenn Berry's Dr. DMV Scripts.
You could also take a look at the book by Grant Fritchey on execution plans.
http://www.amazon.com/Server-Execution-Plans-Grant-Fritchey/dp/1906434026
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
March 20, 2010 at 12:22 am
vikrambansal1 (3/19/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
March 20, 2010 at 12:17 am
Paul White NZ (3/19/2010)
READ UNCOMMITTED gets a bad...
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
March 20, 2010 at 12:09 am
Paul White NZ (3/19/2010)
Kevin Bullen (3/18/2010)
I've run SET STATISTICS PROFILE ON, the execution plan is the same on both servers.
Seems to be, but I agree it would be interesting to...
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
March 20, 2010 at 12:07 am
Paul White NZ (3/19/2010)
CirquedeSQLeil (3/19/2010)
I'll award back points later for everyone on this one since it's not really a fair question, but thanks for all the comments.
That would be nice...
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
March 20, 2010 at 12:05 am
sistemas_casinomnes (3/19/2010)
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[PedidosSeleccionar]
@idmasterpedido int=Null,
@idsector int=Null,
...
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
March 20, 2010 at 12:04 am
Dan B (3/19/2010)
Server[@Name='XXXX']/Database[@Name='master']/Table[@Name='DeadlockEvents' and @Schema='dbo'] ...
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
March 20, 2010 at 12:02 am
Yes that is the command we are referring to.
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
March 19, 2010 at 11:59 pm
Paul White NZ (3/19/2010)
CirquedeSQLeil (3/19/2010)
I am going to post a blog on what I did with this script.Good idea. Should be an interesting read.
Blog is posted.
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
March 19, 2010 at 11:54 pm
Viewing 15 posts - 16,141 through 16,155 (of 19,560 total)