Viewing 15 posts - 5,326 through 5,340 (of 19,560 total)
SanDroid (1/4/2013)
SQLRNNR (1/3/2013)
dineshbabus (1/3/2013)
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
January 4, 2013 at 1:38 pm
opc.three (1/4/2013)
From the resource-list it looks like you might have things accessing resources in...
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
January 4, 2013 at 1:37 pm
What is the average run time for your ERP process?
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
January 4, 2013 at 1:00 pm
Each of those plans are associated to each process that is captured. It looks as though the sp_executesql is executing the parameterized query. You have the same 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
January 4, 2013 at 12:50 pm
There is an option that does not require you to to log on and off and back and forth.
Create an SSMS shortcut that relies on the Runas and specify your...
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
January 4, 2013 at 12:47 pm
We have done it as a joint effort.
This is not just a database cluster, it is also a windows cluster. There are two clusters installed - the os 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
January 4, 2013 at 12:20 pm
Lowell (1/4/2013)
MSSQL_NOOB (1/4/2013)
Is this security or stupidity?
a little of both, i think.
I agree it could be a little of both. Many shops use two accounts in AD -...
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
January 4, 2013 at 12:13 pm
I see that you have captured three processes in this deadlock graph. All three of these are running the same code. Have you checked what the code 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
January 4, 2013 at 12:09 pm
I will be scheduling additional testing. I also have a few more checks that I will be implementing.
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
January 4, 2013 at 11:09 am
crookj (1/4/2013)
SQLRNNR (1/3/2013)
Daniel Bowlin (1/3/2013)
SQLRNNR (1/3/2013)
opc.three (1/3/2013)
SQLRNNR (1/3/2013)
JAZZ Master (1/3/2013)
SGT_squeequal (1/2/2013)
crookj (1/2/2013)
Daniel Bowlin (1/2/2013)
"Back to work (click), back to work (click). Everybody ( click) work,...
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
January 4, 2013 at 11:07 am
Vegard Hagen (1/4/2013)
I'm "impressed" that a vendor like Symantec would actually make such recommendations. I mean...
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
January 4, 2013 at 11:04 am
Glad it is working for you.
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
January 4, 2013 at 10:57 am
homebrew01 (1/4/2013)
Have them run a job ? That might work, but I'd need a way to let them start that job, which I doubt they can do.
One thing we...
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
January 4, 2013 at 10:46 am
Dineshbabu (1/4/2013)
SQLRNNR (1/4/2013)
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
January 4, 2013 at 12:34 am
Like Dwain said,
change this line
and n.Note like '%[0-9A-Za-z.][@] [0-9A-Za-z.]%'
to this
and n.Note like '%[0-9A-Za-z.][@][0-9A-Za-z.]%'
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
January 4, 2013 at 12:30 am
Viewing 15 posts - 5,326 through 5,340 (of 19,560 total)