Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Performance Tuning Expand / Collapse
Author
Message
Posted Tuesday, October 17, 2006 3:22 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 11, 2011 5:16 AM
Points: 24, Visits: 51
Comments posted here are about the content posted at temp


Post #316071
Posted Wednesday, October 25, 2006 1:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 25, 2006 1:42 AM
Points: 1, Visits: 1
Don't forget to download the chapter 28 from the book. It's 48 pages about performance tuning.
Post #317825
Posted Wednesday, October 25, 2006 10:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 3:38 PM
Points: 23, Visits: 55

When I try to execute

select object_name(object_id),
 index_id,
 index_type_desc,
 avg_fragmentation_in_pct
from sys.dm_db_index_physical_stats(db_id(),null,null,null,'limited')

on my server, I get the following error:

Server: Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '('.

Anybody else having this problem?  If you can, please reply to bscrivener@hcad.org.  Thanks.

Post #318002
Posted Wednesday, October 25, 2006 11:46 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:34 AM
Points: 6,259, Visits: 2,031
That error is because you are probably connected to a database that has compatibility level set to 8.0 (2000) instead of 9.0 (2005)

Cheers,




* Noel
Post #318026
Posted Friday, October 27, 2006 10:43 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 6, 2012 9:12 AM
Points: 500, Visits: 183

Actually this is more of a web site comment.

Because of the layout style there's no way for me to view the ends of all the sentances.  Even with IE full screen the right side is cut off.   This happens a lot.

eg "Data warehouse designs, on the othe" [... hidden text...] "Star or Snowflake design" or "As ragmentation increases, data will become spread out over mo" [... hidden text...] "your query needs to retrieve, the slower the query."  Whole sentances inbetween are missing.

An unfortunate disservice to an article the 2/3rds of which I could read looks very interesting.

This is a great site and I've come here for a couple years but the unconstrained content area is really frustrating.  If this happens to you please join me in patient occasional reminders to the busy guys who run SSC.  I'll chime in again about it in a few months, this is my third one. 

To their credit there is no other site on earth I'm willing to read via view source.

just my 2c

 



Skål - jh
Post #318782
Posted Thursday, November 8, 2007 12:24 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
None of the bullets in the article include one of the most important aspects of performance tuning there is... one, that if not present, will bring the most robust hardware and all other tuning methods right to its knees. It's usually overlooked, it's usually given the least time to accomplish, and it seems it's been "mastered" by only an elite relative few...

...writing good solid high performance set based scalable code to begin with. ;)


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #419936
Posted Thursday, November 8, 2007 12:48 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
I just started going through the free chapter... glad to see there's some consideration for writing good code in there... maybe there's more in the rest of the book, but most of the tuning recommendations revolve around hardware, indexes, and a couple of things to avoid like unnecessary ORDER BY's... all of which are mute points in the presence of real crap code.

The chapter also seems to have a high implication for GUI interfaced code... not much on batch code where the really big performance problems creep in. That fact is exemplified by the demo of sp_ExecuteSQL which really only benefits the necessary repetative RBAR nature of GUI code.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #419940
Posted Friday, September 5, 2008 6:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 10, 2011 7:50 AM
Points: 7, Visits: 85
try this:
"SELECT * FROM sys.databases WHERE compatibility_level < 90"
and u'll see the database that has compatibility level set to 8.0

a good day,
Vio
Post #564530
Posted Wednesday, August 17, 2011 7:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:15 AM
Points: 1,159, Visits: 4,659
noeld (10/25/2006)
That error is because you are probably connected to a database that has compatibility level set to 8.0 (2000) instead of 9.0 (2005)

Cheers,

<img src='images/emotions/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'>


Nope the DMV will work even its compatibility level set to 80.


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #1161137
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse