Browse by Tags

• /3gb
• 2000
• 2005
• 3gb
• 64 bit
• audit
• authentication
• awe
• best practice
• bol
• books online
• buffers
• clustering
• cpu
• databases
• disable
• dmv
• edition
• enterprise
• failover
• instances
• kerberos
• login
• logins
• management
• memory
• microsoft
• mixed
• monitoring
• pae
• paging out
• password
• performance
• policy
• sa
• security
• server
• sql authentication
• sql server
• verison
• worker threads

SQL Server error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.
07 March 08 03:54 AM | SQL Master | 2 Comments   

Have you seen the above message within the SQL Server error logs? If not then no need to worry and make sure to continue your performance monitoring tasks. So when to be concerned! It is evident that SQL Server 2005 component handles memory differently Read More...

Filed under: performance, sql server, dmv, memory, windows, awe, monitoring, worker threads, 2005, 2000, paging out, 64 bit, verison, buffers

SQL Server logins - enforce Password Expiration and policies
07 January 08 12:11 PM | SQL Master | 2 Comments   

Here is a quick snippet on enabling a SQL login to password expiration and password policies as per the Windows server: Open the SQL Server 2005 Management Studio. In the left pane, go to the desired server and navigate to the Security folder and expand Read More...

Filed under: sql server, security, windows, authentication, best practice, logins, bol, sql authentication, books online, password, policy

Information and issues with Kerberos security within SQL Server 2005?
31 August 07 02:45 AM | SQL Master | 2 Comments   

What is the Kerberos Authentication? What are the security features difference between Windows 2000 and 2003 versions? How it is behaved within Failover Clustering? How to enable Kerberos Authentication Including SQL Server Virtual Servers on Server Clusters? Read More...

Filed under: security, audit, windows, authentication, clustering, failover, kerberos, sql server

More than 3GB memory is not used even though boot.ini has these switches on /3GB /PAE /AWE.
23 August 07 02:33 AM | SQL Master | 3 Comments   

Yet another AWE memory settings blog post here that I'm posting for the issues we have had recently. Before going into details review about 3GBPAE blurb here and also refer to this KBA274750 to enable more than 2GB memory within your SQL Server Enterprise Read More...

Filed under: performance, sql server, security, memory, windows, instances, enterprise, pae, awe, 3gb, edition

Disable SA account on a live SQL Server2005 instance, any drawbacks?
13 August 07 02:03 AM | SQL Master | 2 Comments   

Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more Read More...

Filed under: sql server, microsoft, security, management, login, windows, mixed, authentication, sa, disable

/3GB /PAE and AWE blurb what is it you hear within your environment?
25 July 07 07:06 AM | SQL Master | 4 Comments   

You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From Read More...

Filed under: performance, sql server, microsoft, security, server, management, memory, windows, pae, awe, /3gb

Using DMVs is it possible to identify whether CPU is hyper-threaded?
29 May 07 06:12 AM | SQL Master | (Comments Off)   

SYS.dm_os_sys_info DMV delivers most important information such as Operating System CPU tick count, hyperthread ratio, physical and virtual memory, as well as the worker and scheduler counts. From the derived values of this DMV if you observe hyperthread_ratio Read More...

Filed under: server, dmv, databases, windows, cpu