I'm confused....

The secondary result set returned from sp_helpdb 'DBName' returns details of the data files and has no reference to any database objects.

The 'name' column of the secondary data set...

That will certainly help as you need to restart the SQL Server Service after you have enabled the AWE configuration option, in order for it to take effect.

You should...

Have you run DBCC CHECKDB on the database?

The following article may be of use to you as it has specific reference to your error.

http://support.microsoft.com/kb/967164

Let me know how you get on.

How are you determining how much memory SQL Server is using?

The task manager will not show memory that is allocated via AWE.

The best way to see how much memory...

Hi,

You can use DDL Triggers to record/log when a CREATE TABLE statement is issued. This can in turn be used to record details of the login that executed the statement.

See...

Hi there,

The deciding factor will be determined by the size of your image files.

If they are relatively small in size i.e. less than 1MB then storing within the database is...

Hi,

I guess we are actually wishing to discuss memory here 🙂

May I suggest you take a look at the following thread.

http://www.sqlservercentral.com/Forums/Topic679203-146-1.aspx

Cheers,

Glad to help MJ!

Cheers,

Hi,

I am not certain that you need to do anything however, I do beleive that SQL Server 2005 handles linked servers differently to SQL Server 2000.

What I would suggest is...

Hi Michael,

The DBCC statements you issued will not reduce the size of the buffer pool (the specific area of SQL Server memory that is used to store data pages).

DBCC freeproccache:...

Hi,

The Buffer Cache, is an area within the Buffer Pool and is in simple terms the amount of your database data that is stored in memory.

So for example, if you...

mirde (3/16/2009)

---

Don't mean to hyjack this thread, but when running the report on our production server (64bit win2003) I keep getting an error message:

Difference of two datetime columns caused overflow...

One thing to note, when you first run the reports you may recieve the following error:

“the difference of two datetime columns caused overflow at runtime”

If you do, I have a...

You should see no issues whatsover however, if you have a DEV or UAT server at your disposal then I would suggest following the install procedures and testing there...

You're welcome! The Performance Dashboard reports are great, we use them all the time.

If you are pressed for time, why spend 5 minutes writting a query to look at a...