Viewing 15 posts - 19,501 through 19,515 (of 19,563 total)
Found this one very interesting. My initial understanding was that of logs having 8k pages. However - I think it comes down to as Steve said - trivia...
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
July 10, 2009 at 12:10 pm
If your log is full, is your disk full too?
What is the growth set to for your log?
What is your recovery model (full, simple)?
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
July 10, 2009 at 11:58 am
Another reason to have different instances would be (again along the security lines) to better segregate client databases. More politics, more administrative duties.
For your additional instance, is your cluster...
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
July 10, 2009 at 11:51 am
Though this is not my question, thanks Elliott for the answer. This will prove useful in my environment as well.
In addition to using TFS already.
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
July 10, 2009 at 11:42 am
You can create some procs that will take care of your reindexing needs. When creating the procs you can set them up as startup procs so they will 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
July 10, 2009 at 10:29 am
Nice article. This could prove very useful.
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
July 10, 2009 at 10:19 am
That should have done it for you. I have seen though that the freeprocindb sometimes doesn't clear it like we would want. Though all plans would be removed...
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
July 9, 2009 at 6:55 pm
Please provide us a sample query that might be using this structure (provide a sample of the schema too please).
Do you have clustered indexes on the underlying tables?
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
July 9, 2009 at 6:03 pm
If you were on sql2k5, I would suggest creating a ddl trigger to help monitor for this.
The DDL trigger in 2k5 can monitor for create, alter and drop events related...
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
July 9, 2009 at 5:48 pm
Select job type as cmdexec from within a new job / job step properties.
Give it a command such as :
DTSRun /S"Servername" /E /N"DTSPackageName"
It should be able to do it without...
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
July 9, 2009 at 5:38 pm
have you looked at the gui options?
tools - options - query execution - SQL Server - Advanced
and
tools - options - query execution - SQL Server - ANSII
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
July 9, 2009 at 4:31 pm
Good List by Michael. Excellent point by Jeff concerning the code review.
Review, review, and review some more the developer code.
I would like to throw in to the mix a...
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
July 9, 2009 at 1:18 pm
try dbcc freeproccache
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
July 9, 2009 at 12:50 pm
Maple data is better than honey data 🙂
Of the last two supplied queries, my preference would be for the first. That said, it would be best to do 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
July 9, 2009 at 11:15 am
I would definitely use the first two questions for an entry level type position.
Based on recent experience, we have encountered 50+ candidates who could not answer questions such as these....
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
July 9, 2009 at 11:09 am
Viewing 15 posts - 19,501 through 19,515 (of 19,563 total)