Viewing 15 posts - 15,511 through 15,525 (of 19,560 total)
gmamata7 (4/1/2010)
exec sp_import_errorlog
@log_name =errorlog,
@log_number = 0,
@overwrite = 0
but getting the below error:
Msg 213, Level 16, State 7,...
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 2, 2010 at 8:19 am
GilaMonster (4/2/2010)
Mani-584606 (4/1/2010)
So is that normal to have low PLE while running DBCC CHECKDB?
Absolutely. CheckDB reads every allocated page in the entire database, hence you're going to have 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
April 2, 2010 at 8:17 am
Paul White NZ (4/1/2010)
CirquedeSQLeil (4/1/2010)
Thanks for the links Paul.Actually, my advice is to read everything Craig F has ever written!
Thanks - I will look into more of his stuff.
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 2, 2010 at 8:16 am
Since a CHeckDB also performs a checktable (which checks all of the pages in the database), it would seem that it should drop the PLE very low. Somebody else...
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 1, 2010 at 7:44 pm
See how this really isn't just a simple question?
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 1, 2010 at 7:34 pm
Lynn Pettis (4/1/2010)
CirquedeSQLeil (4/1/2010)
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 1, 2010 at 7:31 pm
Definitely add logging to the package.
http://msdn.microsoft.com/en-us/library/ms167456.aspx
This package ends and terminates properly when run from bids?
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 1, 2010 at 6:46 pm
JC-3113 (4/1/2010)
what is SQL RNNR ?Jim
My blog and twitter handle.
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 1, 2010 at 6:35 pm
JC-3113 (4/1/2010)
Hi Steveall my databases are on a Windows 2003 servere running SQl Server 2005 though
Jim
Which means you would have to update to SQL 2008. Steve recommended that 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
April 1, 2010 at 6:35 pm
Leon, I would recommend you follow the advice by Toby. Though User connections will take a nominal amount of memory, you need to scale for the application 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
April 1, 2010 at 6:26 pm
This means that a database is working correctly on SQL 2008.
You should do this in a dev environment first, then a UAT environment and test all of your applications.
Once 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
April 1, 2010 at 6:01 pm
None of these things are to be taken lightly. Each must be considered.
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 1, 2010 at 5:58 pm
sivaprasad (4/1/2010)
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 1, 2010 at 5:56 pm
Yes there needs to be foreign keys in the database. Furthermore, there needs to be indexes built on those keys.
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 1, 2010 at 5:46 pm
What kinds of indexes are you seeing that actually increase in fragmentation?
How many pages are on each of the indexes?
What is the before and after fragmentation % level?
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 1, 2010 at 5:40 pm
Viewing 15 posts - 15,511 through 15,525 (of 19,560 total)