You need not do anything special in profiler for that. Just create a new profiler trace and trace sql statements and stored procedures running against sql server. This will show...

If indexes are defragged and statistics are up to date then try passing the profiler workload file to DTA and see what advisor says. Is this happening at any specific...

Is that doamin account having privileges mentioned under

http://msdn.microsoft.com/en-us/library/ms143504.aspx

MJ

ALTER DATABASE Test1

ADD FILE

(

NAME = Test1dat2,

FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\t1dat2.ndf',

SIZE = 5MB,

MAXSIZE = 100MB,

FILEGROWTH = 5MB

)

GO

http://msdn.microsoft.com/en-us/library/aa275464(SQL.80).aspx

MJ

Remove WITH (NOLOCK) and then compare.

MJ

Check the value of awe enabled under sp_configure output.

MJ

Yes, we can as in 2005 this can be controlled by OS and applicable for SQL Server logins if password policy option is checked under login screen.

MJ

Yes, you need to set max server memory when running under dynamic memory configuration.

To check Right Click Server Name under EM-->Memory Tab-->...

MJ

Have this included in your restore statement after restore code

use [cs_DotNetNuke]

EXEC sp_addrolemember N'db_datareader', N'S602561DC4EW31\GPWebUser'

EXEC sp_addrolemember N'db_datawriter', N'S602561DC4EW31\GPWebUser'

HTH!

MJ

This is controlled by OS level setting

http://technet.microsoft.com/en-us/library/cc758659.aspx

MJ

Max server memory should be configured so tht you leave 1-1.5GB of memory for OS. In case there are other applications running on this server then you need to reduce...

Then try creating a new login with same name as this user and associate that login with this user. Once it comes up under security-->users GUI then drop the user...

Can you plz post the output of

USE Databasename

sp_spaceused @updateusage = 'TRUE'

MJ

SQL Server 2005

In SQL Server 2005 the process of implementing Log Shipping is embedded with the Workgroup, Standard and Enterprise editions of SQL Server. To implement it, right click...

Is this resolved?

MJ