Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Server 2008 License

Author  Topic 

chriztoph
Posting Yak Master

184 Posts

Posted - 2010-04-19 : 21:12:07
Hi everyone..

i have my problem regarding SQL Server Licensing, We have SQL server 2008 License which is per CAL then my boss bought another SQL server 2008 which is per Processor..Now, how can i change the type of license of the SQL Server? I have read some of the post which is in registry but i don't how..Can you give the Step-by-step procedure how to change the licensing type?


I have one more question, we always having a problem regarding Memory usage of the SQL Server.. Why the % Processor Time always goes 99% which cause of slowing down of the connection of all the applications? How to Configure the SQL server to not the % of the Processor time goes high.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-20 : 12:05:53
For the memory/CPU question, you need to see if you are missing indexes that are causing table scans. Check SQL Profiler for long running queries and then figure out if indexes need to be added.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

chriztoph
Posting Yak Master

184 Posts

Posted - 2010-04-20 : 20:37:03
Thanks.. I'll check it..

How about the licensing?
Go to Top of Page

chriztoph
Posting Yak Master

184 Posts

Posted - 2010-04-21 : 03:16:47
do i need to build an index for views?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-21 : 12:20:07
I don't have the answer for your licensing question.

You do not NEED to build indexes on views. Views can use indexes on the underlying tables. However there are very good uses for indexes on views (known as indexed views), but they are rarely used.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

RobertKaucher
Posting Yak Master

169 Posts

Posted - 2010-04-22 : 16:15:16
Try running the Installation Wizard again and look under -> Maintenance -> Edition Upgrade. This may allow you to enter the new product key. Otherwise, yes you have to go through the registry. But I expect that will work for you.

===
http://www.ElementalSQL.com/
Go to Top of Page
   

- Advertisement -