Viewing 15 posts - 2,986 through 3,000 (of 19,560 total)
Sean Lange (5/29/2014)
Ed Wagner (5/29/2014)
SQLRNNR (5/29/2014)
Sean Lange (5/29/2014)
SQLRNNR (5/29/2014)
Sean Lange (5/29/2014)
Ed Wagner (5/29/2014)
Sean Lange (5/29/2014)
Ed Wagner (5/29/2014)
Sean Lange (5/29/2014)
Stuart Davies (5/29/2014)
Ed Wagner (5/29/2014)
Sean Lange (5/29/2014)
SQLRNNR (5/29/2014)
CAMShaft
Rotation
Axis
Allies
Board Game
Classic!
Shogun (same series as...
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
May 29, 2014 at 10:34 am
Sean Lange (5/29/2014)
SQLRNNR (5/29/2014)
Sean Lange (5/29/2014)
Ed Wagner (5/29/2014)
Sean Lange (5/29/2014)
Ed Wagner (5/29/2014)
Sean Lange (5/29/2014)
Stuart Davies (5/29/2014)
Ed Wagner (5/29/2014)
Sean Lange (5/29/2014)
SQLRNNR (5/29/2014)
CAMShaft
Rotation
Axis
Allies
Board Game
Classic!
Shogun (same series as Axis and Allies)
Classic! (have that...
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
May 29, 2014 at 10:07 am
Sean Lange (5/29/2014)
Ed Wagner (5/29/2014)
Sean Lange (5/29/2014)
Ed Wagner (5/29/2014)
Sean Lange (5/29/2014)
Stuart Davies (5/29/2014)
Ed Wagner (5/29/2014)
Sean Lange (5/29/2014)
SQLRNNR (5/29/2014)
CAMShaft
Rotation
Axis
Allies
Board Game
Classic!
Shogun (same series as Axis and Allies)
Classic! (have that one too :-))
Haven't...
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
May 29, 2014 at 9:58 am
You are welcome.
fwiw - here is a script to help see the table and index sizes a little more clearly.
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
May 29, 2014 at 9:52 am
Also, with it being slow for some, it sounds like it works quickly for others. Is that a valid assertion?
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
May 29, 2014 at 9:29 am
How frequently does the data on this dashboard need to be updated? Is it an hourly thing, daily thing or up to the second type of thing?
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
May 29, 2014 at 9:28 am
You can use a query such as this
SELECT DB_NAME(fs.database_id) AS DBName ,
mf.file_id ,
mf.type_desc...
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
May 29, 2014 at 9:24 am
Your [Dead_Lock_Log] [varchar](max) probably had some off-row data (blobs). If you recently deleted the records, the size information can lag behind due to the blob info.
Have you run...
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
May 29, 2014 at 9:20 am
I agree with Greg.
Looking at just one VM on the host seems to be overkill for the VM. If you are looking into DR that means a additional servers...
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
May 29, 2014 at 8:10 am
Scripting and automation are great tools. They are perfect tools for lazy DBAs (we like to not have to do the same manual thing over and over). Sure...
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
May 29, 2014 at 7:58 am
A lot of it boils down to resource requirements and how you configure the VM.
To convince people one way or the other requires a bit of a dog and pony...
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
May 29, 2014 at 7:53 am
CAM
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
May 29, 2014 at 7:30 am
crookj (5/29/2014)
Ed Wagner (5/29/2014)
aaron.reese (5/29/2014)
Ed Wagner (5/29/2014)
Sean Lange (5/28/2014)
Ed Wagner (5/28/2014)
whereisSQL? (5/28/2014)
Ed Wagner (5/28/2014)
Sean Lange (5/28/2014)
crookj (5/28/2014)
Ed Wagner (5/28/2014)
BWFC (5/28/2014)
GeeseHunting
:Wabbitt!
Duck!
Baseball
Steroids
Cheating
Marriage
Commit
Rollback (Topical :-D)
Savepoint
Snapshot
isolation
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
May 29, 2014 at 7:18 am
jasona.work (5/29/2014)
Ars Technica: "TrueCrypt is not secure"[/url]
Reading comments elsewhere (Theregister.co.uk) one commenter suggested that rather than this being a plot by 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
May 29, 2014 at 7:10 am
tshad (5/28/2014)
That was it.Thanks
You're welcome.
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
May 29, 2014 at 7:04 am
Viewing 15 posts - 2,986 through 3,000 (of 19,560 total)