Viewing 15 posts - 10,456 through 10,470 (of 19,560 total)
GilaMonster (4/12/2011)
jcrawf02 (4/12/2011)
Even when I know what's going on, I'm confused.How do you think I feel? :hehe:
Keep in mind that it is April Fools month 😎
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 12, 2011 at 3:43 pm
GilaMonster (4/12/2011)
WayneS (4/12/2011)
Jack Corbett (4/12/2011)
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 12, 2011 at 3:16 pm
Are you experiencing any signs of slowness in queries?
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 12, 2011 at 3:00 pm
That was a great exchange - it was almost as if you guys had planned it that way.
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 12, 2011 at 2:33 pm
Check the permissions on the model files. A readonly attribute may be set, or your account permissions may have gotten fouled up during the move.
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 12, 2011 at 1:53 pm
Grant Fritchey (4/12/2011)
I'M SPARTACUS!Uh, I mean, I'm a Gila Monster too. Really.
Now may the confunsion really begin
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 12, 2011 at 1:49 pm
opc.three (4/12/2011)
CirquedeSQLeil (4/12/2011)
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 12, 2011 at 1:41 pm
WayneS (4/12/2011)
Craig Farrell (4/12/2011)
WayneS (4/12/2011)
Jack Corbett (4/12/2011)
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 12, 2011 at 1:28 pm
I think this will help you map them properly.
http://msdn.microsoft.com/en-us/library/ms143547(v=SQL.90).aspx
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 12, 2011 at 1:19 pm
I can't tell from the first post, but did you do the same sort of thing for your resource database (moved the files to a folder schema with naming convention...
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 12, 2011 at 1:02 pm
dant12 (4/12/2011)
ok, i got the first part, finding where it isex:
select B.* from table cross apply sys.fn_PhysLocCracker(%%physloc%%) B
Excellent nugget.
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 12, 2011 at 12:49 pm
you can migrate all of into a single file by creating a new filegroup with a single file in it. Rebuild your clustered index on the table and redirect...
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 12, 2011 at 12:46 pm
What is your min memory setting?
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 12, 2011 at 12:41 pm
A logon trigger that records the event to a table should suffice. Dump the ip, hostname, username, event time etc to that table and you would start to get...
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 12, 2011 at 12:39 pm
Craig Farrell (4/12/2011)
WayneS (4/12/2011)
Jack Corbett (4/12/2011)
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 12, 2011 at 12:35 pm
Viewing 15 posts - 10,456 through 10,470 (of 19,560 total)