Check the execution plan of stored procedure and under that check for queries whose cost is high(parameter: query cost relative to batch percentage)...

Manu

Can you share the template code with me by sending it across at my personal id(manujaidka@rediffmail.com)?

What in case we need to run same query against different databases residing on different...

You can do that but better try not performing this operation as it won't allow you to attach the database again(I have seen it happening most of the times).

Manu

Regarding 16 GB memory usgae try leaving atleast 1 GB for operating system. Yes, you can use /3 GB switch in this case. Regarding hotfix I can't say anyhting--experts please...

Please try running the t-sql command for backup statement(ran by sql-safe) under query analyzer manually and see what it shows in error message.

Manu

Use WITH MOVE parameter under restore database statement and specify the path that is available(I think you want tp place master files in E drive here).

Manu

Nope you can't.

Manu

No need to change anything on memory allocation side.

Just go thru the below mentioned links to find usefulness of Lock Pages in Memory option:

http://kbalertz.com/918483/enable-pages-memory-permissions-prevent-Server-buffer-memory-being-paged-physical-memory.aspx

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

Let me know...

From DBCC Memorystatus output it looks you are not making use of AWE(thts fine as this is 64-bit..).

Have you assigned Lock Pages in Memory privilege to sql server service...

Please mention sql server edition, available memeory and memory assigned to SQL Server, usgae of /3GB switch and PAE, AWE status...

If possible, please attach screenshot of DBCC MEMORYSTATUS output.

Manu

Hope this helps:

http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/fdb55963f509647f/71311fa83ba63410?lnk=st&q=xp_sendmail+%40user&rnum=4&hl=en#71311fa83ba63410

Manu

I think Gail is talking about trace flag -T3608. Try restarting sql server using -c -T3608 flag. This might allow you to change tempdb files location.

Manu

Nita,

Please make sure AUTOSHRINK option is turned OFF for the database in question.

Also, try shrinking database file in chunks rather than specifying a big size in one shot. Use...

Are you making use of linked servers a lot? Other way round, are there distributed queries that are running from this server?

What value do you see under Process object(Virtual Bytes...

I don't know whether this will work or not:

Can you try changing the table type from User to System by making use of following stored procedure:

In Sql Server 2000--master.dbo.sp_MS_upd_sysobj_category

In...