Search Results | SQL Server Performance Forums

sql server memory issue

Thread by: danan_xu, Nov 6, 2005, 14 replies, in forum: General DBA Questions

Can anyone help me on this memory issue? memory configuration issue: one server box(win2003 EE sp1) with 8GB ram, win 2003 sp1 and sql sever 2000...

SQL database server memory configuration issue(8GB

Thread by: danan_xu, Nov 2, 2005, 2 replies, in forum: Performance Tuning for DBAs

SQL database server memory configuration issue: one server box with 8GB ram, win 2003 sp1 and sql sever 2000 sp 3 installed. I have done: -added...

database server 100% cpu usage

Thread by: danan_xu, Jun 26, 2005, 10 replies, in forum: General DBA Questions

Gents: I just encountered one problem with our db server, which has been with 100% cpu usage all day for a few days. Before It was busy with 80% cpu...

Werid problem with MSDTC

Thread by: danan_xu, Jun 5, 2005, 1 replies, in forum: SQL Server Clustering

Dear all: I just experienced a strange problem with our cluster, Node A was active node and running well before I fail over all service to node B....

question on collation

Thread by: danan_xu, May 26, 2005, 7 replies, in forum: General DBA Questions

guys: want to ask which collation I need to use when I create a database - windows collation or sql server collation? regardingless the legacy...

any way to script linked server?

Thread by: danan_xu, May 19, 2005, 1 replies, in forum: General DBA Questions

Deal all, I want to ask if there is any script to 'script' linked server automatically instead of manually creat it. thanks for your time

the order to restart sql cluster server

Thread by: danan_xu, May 18, 2005, 6 replies, in forum: SQL Server Clustering

hi, guys: want to ask you a question which might be quite simple for you. I need to restart cluster server ( windows 2003 & sql 2000 sp3,...

question with sql job (error 22022)

Thread by: danan_xu, May 17, 2005, 6 replies, in forum: General DBA Questions

Dear all: I tried to manually start a job from Enterprise Manager and got ' Error 22022: Unable to post notification to SQL ServerAgent (reason:...

use restore msdb on new database server

Thread by: danan_xu, May 4, 2005, 0 replies, in forum: General DBA Questions

Dear all: after I checked some posts here regarding move sql from normal to cluster environment, everyone seems prefer using other methods other...

Urgent question - restore db from only .mdf file

Thread by: danan_xu, Apr 27, 2005, 30 replies, in forum: General DBA Questions

guys: It's really urgent. Can anyone give me advice on how to restore db form only .mdf file. ( .ldf file has been deleted!) I tried...

Error - Incorrect syntax near 'collate'.

Thread by: danan_xu, Apr 12, 2005, 20 replies, in forum: General DBA Questions

Hi, guys: I have two tables a use collation - SQL_Latin1_General_CP1_CI_AS b use collation - Latin1_General_CI_AS when I run the following...

can' run new created jobs on sql

Thread by: danan_xu, Apr 11, 2005, 13 replies, in forum: General DBA Questions

Just got reported by developer that new created job stuck on sql server. Also I built a very simple job to run 'select * from sysdatabases' every...

move sys db from old db server to new cluster serv

Thread by: danan_xu, Apr 10, 2005, 6 replies, in forum: General DBA Questions

dear everyone: I am making the plan to move dbs from old production db server to new cluster db server. In order to reduce the downtime, I should...

sync db

Thread by: danan_xu, Apr 6, 2005, 2 replies, in forum: SQL Server DTS-Related Questions

one is dev db-A1, one is staging db-A2. A2 has one table with 300 Million records but the table with same name on A1 has only 20 for development....

how to check if db is active

Thread by: danan_xu, Apr 6, 2005, 7 replies, in forum: General DBA Questions

Now I just started my dba role in a new company, and am responsible for a lot of dbs. some of them are not active, I know sql trace can help to...