Search Results | SQL Server Performance Forums

Insufficient memory available in SQL 2000

Thread by: sramesh, Sep 29, 2009, 13 replies, in forum: General DBA Questions

Hi , I have received below erro and one of the application has been terminated same time.SQL Version : 2000 Enterprise EditionService Pack:...

Database restore is taking more than 5 hours

Thread by: sramesh, Aug 19, 2009, 5 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, I have tried to restore the database from a network share. The backup file size is 350 GB. First 1 hour 30 mins i didnt find any progress...

SQL 2005 SP3 failed

Thread by: sramesh, Aug 13, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, Today i have installed SQL 2005 SP3 but failed with below error. While checking, i found SP3 is applied successfully. i can confirm the same...

SQL AWE is leads issues

Thread by: sramesh, Aug 1, 2009, 1 replies, in forum: General DBA Questions

Hi all, My environment is SQL 2000 enterprise edition, Windows 2003 Enterprise Edition, 12 CPU and 8 GB RAM. I have done below. 1. Added /3GB /PAE...

SQL 7 Migration

Thread by: sramesh, Nov 18, 2008, 2 replies, in forum: General DBA Questions

Hi all, I have planned to move all databases from serverA to ServerB. Both servers are production server with same collation and same SQL Version....

AWE enabel

Thread by: sramesh, Sep 15, 2008, 4 replies, in forum: General DBA Questions

I want increase SQL Server memory usage from 1800 MB to 2500 MB. Currently SQL Server occupied 1800 MB Ram. Please tell me how to enable AWE in SQL...

Urgent--- How to get statements in profiler

Thread by: sramesh, Sep 4, 2008, 4 replies, in forum: General DBA Questions

i had run SQL profiler with following events, sp:statementstarting, SQL:Statemenstarting, Lock:escalation. I have all trace file. but i need to...

how to reduce lazy writes in sql 2000

Thread by: sramesh, Aug 29, 2008, 10 replies, in forum: General DBA Questions

hi all, The procee id 1 is blocking other process frequnetly. when checked, we found lazy write status. some one please tell me how to reduce lazy...

DBCC check db throws errors

Thread by: sramesh, Aug 22, 2008, 1 replies, in forum: General DBA Questions

Hi all, I got 27 allocation error. How to clear allocation errors? Server: Msg 8968, Level 16, State 10, Line 0 Table Corrupt: IAM page (1:3402)...

Force restore issue

Thread by: sramesh, Jun 25, 2008, 3 replies, in forum: General DBA Questions

Hi all, I have backep one database and restored the same in another one server. The other server already have same database. After restore, the...

DB Reindexing problem

Thread by: sramesh, Jun 11, 2008, 6 replies, in forum: General DBA Questions

Hi All, I have configured DB reindexing job for a 24 x 7 database. I need script or solution for exclude reindexing for user access tables. How...

Index Tuning Wizard issues

Thread by: sramesh, Mar 28, 2008, 2 replies, in forum: Performance Tuning for DBAs

Hi All, I got error while executing the Index tunning wizard. Error Message: There are no events in the workload. either the trace file contained...

SQL Server Security

Thread by: sramesh, Mar 6, 2008, 2 replies, in forum: General DBA Questions

Hi All, I have mixed mode authentication sql server. I want secure my server, because domain admins are able to access my server, local...

SQL Server License

Thread by: sramesh, Feb 14, 2008, 4 replies, in forum: General DBA Questions

Hi, Is it require license for sql server 7.0 because i heard the support for sql 7 was ended? Please clear my doubts

Urgent- How to update hotfix for sql server 7

Thread by: sramesh, Jan 29, 2008, 4 replies, in forum: General DBA Questions

Hi, I have sql server 7 and sp4 applied. The current version number is 7.00.1087. I want apply remaining hot fix up to 7.00.1150. Please suggest how...

SQL Agent log cycling

Thread by: sramesh, Jan 21, 2008, 1 replies, in forum: General DBA Questions

Can someone help me, how to cycle the agent logs in SQL Server, without restarting SQL Agent Service.

SQLserver exe occupied more memory

Thread by: sramesh, Jan 7, 2008, 8 replies, in forum: General DBA Questions

Hi All, The sql server exe occupied 6 gb of memory. I have checked process details in sysprocesses table, but i did not found any high mem usage...

Not able to terminate the processes

Thread by: sramesh, Nov 26, 2007, 1 replies, in forum: General DBA Questions

Hi all, I am not able to terminate a processes which is locking more than 3 days. I want terminate that processes without restart the service. The...

How to enable alert for locking

Thread by: sramesh, Nov 23, 2007, 2 replies, in forum: General DBA Questions

hi I want enable alert for lock which is happened more than 5 mins? How to enable? In future I want enable all possible alerts. Please provide...

How to script full text catelog

Thread by: sramesh, Nov 21, 2007, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, I want script all full text catelog and indexes in sql 2000 and I want execute the script in SQL 2005 server. Any body have script for full...