Viewing 15 posts - 3,301 through 3,315 (of 19,560 total)
I think big keys to the problem is what do the corporate policies have in place, what laws are in place, what learning plans have been implemented to try and...
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 27, 2014 at 8:36 am
Intriguing question. I enjoyed it. Thanks
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 27, 2014 at 8:23 am
8 Files for a 4.5GB database is overkill. For a database that small, I would not split the files. I would look to performance tune the code.
That said,...
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 27, 2014 at 8:20 am
From that script it looks like your issue could be one of two things or a combination of both.
Issue #1: You are excluding all tables that are heaps. 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 26, 2014 at 2:50 pm
use alter index ... Rebuild since you are on SQL 2008
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 26, 2014 at 2:34 pm
No.
I do this quite frequently where I add files that are smaller and then rebuild the indexes.
Once the rebuild is complete you can work on shrinking the original file.
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 26, 2014 at 12:35 pm
Is it possible that the app server has a different timestamp than the database server?
It is possible that the app is misreporting it as a deadlock 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
March 26, 2014 at 12:02 pm
If you have several files in the filegroup, set to the same size and set to evenly grow, then a rebuild of the CI or heap will usually split 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
March 26, 2014 at 11:10 am
Try this
SELECT xed.value('@timestamp', 'datetime') as Creation_Date,
xed.query('.') AS Extend_Event
FROM ( SELECT ...
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 26, 2014 at 11:08 am
If your system_health session is running, then you can query the ring buffer (the default output of that session) and maybe find the deadlock.
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 26, 2014 at 10:47 am
You can rebuild the clustered index or the heap for each table.
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 26, 2014 at 10:43 am
I wonder if your share name is causing some issues behind the scenes. C$Z might be trying to resolve to the admin share of C
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 26, 2014 at 10:28 am
Do you have the system_health XE session still running?
Also, where did you confirm that a deadlock happened?
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 26, 2014 at 10:24 am
when you past this path into a run window (start->run), does it produce an error or open an explorer window with contents?
'\\aseposretail\c$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
March 26, 2014 at 10:18 am
deepak.bisht (3/21/2014)
name of the database is tlmainRegards,
Deepak Bisht
Sounds like you are using Talisma. In some cases they named their distribution database as tlmain.
At any rate, distribution databases can have...
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 26, 2014 at 9:15 am
Viewing 15 posts - 3,301 through 3,315 (of 19,560 total)