August 9, 2010 at 5:03 am
Will lack of user licenses cause session blocking? How can I tell if I do not have enough user licenses? All users login to the databse using sa and we have four user access licenses at the moment. number of desktops accessing sql server at anyone time will be 10.
Trying to establish if having 4 licenses when 10 users connected is causing problems?
August 9, 2010 at 5:12 am
It won't cause blocking. Lack of licences will cause you some problems when you get audited.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2010 at 5:24 am
upgraded to sql server 2008 with 4 user cal (clients decision not mine) and since then we've been experiencing lots of session blocks.
August 9, 2010 at 5:34 am
Tell whoever made that decision that having 4 cals and 10 connections will get you some nasty fines when you get audited.
The blocking, however, is not related. What did you upgrade from? 2000? Have you rebuilt all indexes? Updated all statistics? Checked what's blocking and what it's blocked by?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2010 at 5:35 am
p.s. Users using the sa account is one of the worst possible security practices. Get the users their own logins with the minimum permissions they need to do their job.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2010 at 6:16 am
cheers already rebuilding indexes, stats, freeing caches etc once a day.
database is 3GB server has 4GB with 5 drives in raid 5 (client decision) again. Have asked for OS to be on two of them on raid 0 and the other 3 in raid 5 for SQL Server.
Do you think 4GB ram is enough? Windows 2003 32 Bit, can I enable AWE is should they look at upgrading to 64 bit?
1.65 is currently being used by SQL
August 9, 2010 at 6:42 am
email-935809 (8/9/2010)
freeing caches once a day.
Don't do that. You're just making SQL do more work
Do you think 4GB ram is enough? Windows 2003 32 Bit, can I enable AWE is should they look at upgrading to 64 bit?
No idea if 4 GB is enough. That's like asking how long a piece of string is. Without knowledge of your workload there's no way to give a useful answer. AWE is for when you have more than 4GB of memory on the server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2010 at 7:06 am
so don't bother rebuilding indexes, stats, free caches?
August 9, 2010 at 7:10 am
Rebuild indexes - yes.
Update statistics - yes
Empty caches - no. You're just forcing SQL to work harder to repopulate them.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2010 at 7:14 am
cheers will drop the cache clearing.
Moved from SQL Express 2005 to SQL Standard 2008 and load of performance problem since. Wish I had of left it as is. ;-).
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply