Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Highly Rated Users

Forum
No Posts Rated

Top 50
Given
Received

Forum Statistics

Users
Members:
1878
Members Online:
2
Guests Online:
98

Total Post History
Posts:
81448
Topics:
18714

7-Day Post History
New Posts:
1
New Topics:
0
Active Topics:
1

Our newest member
kowilmar1990z

Other

FAQ
All times are UTC [ DST ]

Google Ads

SQL Server 2012 support

Please wait...

SQL Server 2012 support

Postby SuperDave on Tue Oct 30, 2012 3:05 pm

I tried the tool and it works great on my SQL 2008 databases but doesn't return anything on my SQL 2012 databases. Do you guys plan to release a version that supports SQL 2012?
SuperDave
Newbie
Newbie
 
Posts: 1
Joined: Tue Oct 30, 2012 3:04 pm
Unrated

Re: SQL Server 2012 support

Postby skoub on Fri Feb 08, 2013 12:20 am

any news for the SQL Server 2012 support? I would be interested!

alex
skoub
Newbie
Newbie
 
Posts: 1
Joined: Fri Feb 08, 2013 12:19 am
Unrated

Re: SQL Server 2012 support

Postby SQLDenis on Fri Feb 08, 2013 2:26 am

I think all we need to do is add SQL2012 to the sections that have SQL2005 and SQL2012

If you want to test this out yourself, open up the XML file (sqlcop.xml) that is in the same directory as SQLCop, find one of these sections

  1. <versions>
  2.  <version>SQL2000</version>
  3.   <version>SQL2005</version>
  4.   <version>SQL2008</version>
  5. </versions>


add

  1. <version>SQL2012</version>


so hat it becomes
  1. <versions>
  2.   <version>SQL2000</version>
  3.   <version>SQL2005</version>
  4.   <version>SQL2008</version>
  5.   <version>SQL2012</version>
  6. </versions>
User avatar
SQLDenis
LTD Admin
LTD Admin
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
 
Posts: 21784
Joined: Wed Oct 10, 2007 6:43 pm
Location: Princeton, New Jersey, USA,World, Solar System, Milky Way, Universe and Beyond
Unrated

Re: SQL Server 2012 support

Postby SQLDenis on Fri Feb 08, 2013 2:37 am

Instead of SQL2012, it has to be SQL11. I will contact George to see if we can add this sometimes this weekend


I tried it out and it worked for me, see screenshot after I added SQL11 to the buffer cache hit ratio check


SQL11.PNG
You do not have the required permissions to view the files attached to this post.
User avatar
SQLDenis
LTD Admin
LTD Admin
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
 
Posts: 21784
Joined: Wed Oct 10, 2007 6:43 pm
Location: Princeton, New Jersey, USA,World, Solar System, Milky Way, Universe and Beyond
Unrated

Re: SQL Server 2012 support

Postby SQLDenis on Fri Feb 08, 2013 2:45 am

I also suggest we maybe remove SQL 2000 from this but then again someone might get annoyed
User avatar
SQLDenis
LTD Admin
LTD Admin
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
 
Posts: 21784
Joined: Wed Oct 10, 2007 6:43 pm
Location: Princeton, New Jersey, USA,World, Solar System, Milky Way, Universe and Beyond
Unrated