Viewing 15 posts - 19,456 through 19,470 (of 19,560 total)
Caching is what is causing your difference between first and subsequent runs.
First run has to build the actual execution plan and cache it, plus what Lynn said about the physical...
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
August 26, 2009 at 6:44 pm
Here are a couple of things:
A way to determine memory pressure:
select * from sys.sysperfinfo where counter_name like '%page life expectancy%'
if the counters are below 300, you should probably get more...
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
August 26, 2009 at 6:01 pm
I like to affix a cost / benefit value to the missing index (number of updates vs. number of lookups as part of it). From there, try to associate...
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
August 26, 2009 at 5:52 pm
50-60 hr weeks are very common too:hehe:
Nothing like 30hrs straight to get the juices flowing:doze:
But as a DBA if something comes up that requires it, you have to grin 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
August 26, 2009 at 4:49 pm
Just two-bits, at a former employer we used SQL, Oracle, DB2 and Teradata.
The Teradata and Oracle teams were about twice the size of the SQL and DB2 teams. We...
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
August 26, 2009 at 4:23 pm
Sometimes when you buy a license you purchase an upgrade uption, sometimes not. This depends on the vendor. That is why it is a good idea to call...
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
August 26, 2009 at 4:11 pm
Depending on the query, I would also test against CTE. I have found the same sort of result with TVFs when compared to procs as GSquared has found. ...
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
August 26, 2009 at 2:01 pm
Technically the trigger and bcp option would work. The solution of using a scheduled stored proc is superior to the trigger. As for the SSIS scheduled job -...
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
August 26, 2009 at 1:55 pm
And I will table the motion - CLR seems the best option for this type of requirement.
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
August 26, 2009 at 1:48 pm
Not sure why the Encrypted Procs in prod on the 2005 box is an issue. Aren't the procs that you truly need to access in the 2000 box? ...
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
August 26, 2009 at 1:42 pm
If you must implement a linked server, I highly recommend thoroughly testing your queries first and monitoring performance. With linked servers, you want to be careful with the security,...
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
August 26, 2009 at 1:33 pm
Chris Patton (8/26/2009)
We use the filegroup in question for archived...
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
August 26, 2009 at 1:07 pm
Nice topic. I have had to use this as well for searching special characters of this type due to the nature in which the application and database were developed...
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
August 26, 2009 at 1:01 pm
SQL 2005 still supports the following three ways to report data and log space usage for a database:
DBCC SQLPERF ( LOGSPACE ) can tell 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
August 26, 2009 at 11:41 am
This method may be a little longer. Have you considered creating a new filegroup that is readwrite and then moving tables and indexes from the readonly filegroup to 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
August 26, 2009 at 11:18 am
Viewing 15 posts - 19,456 through 19,470 (of 19,560 total)