Search Results | SQL Server Performance Forums

Track Daily Run SQL Statements

Thread by: shreesoft00, Sep 25, 2003, 9 replies, in forum: Performance Tuning for DBAs

Hi How i can See All the Statements and USers Associated with the statements every night? which is run on a particular Day ? I use profiler whole...

Point in time resore problem

Thread by: shreesoft00, Sep 23, 2003, 10 replies, in forum: Performance Tuning for DBAs

Hi all, I am trying to do a point in time recovery on a SQL Server 2000 DB but am running into some issues. (Through Enterprise manager) I can...

one way merge replication

Thread by: shreesoft00, Jul 3, 2003, 2 replies, in forum: Performance Tuning for SQL Server Replication

Hi We have one production site and we want to replicate that data to another database server. one of our DBA is suggesting for merge replication as...

performance went down with more users

Thread by: shreesoft00, Jun 6, 2003, 7 replies, in forum: Performance Tuning for DBAs

I am Facing a problem in my database server with slow perofrmance i have a Databse server with Sql200 enterprise edition these are the...

strange SQL Update problem !!! Plssss Helpp

Thread by: shreesoft00, May 19, 2003, 3 replies, in forum: General DBA Questions

Hi there, i have stuck in a strange prblem in visual basic n sql. I am able to doinserts and update in a table thru visual basic. Now when i...

load testing

Thread by: shreesoft00, May 8, 2003, 4 replies, in forum: Performance Tuning for DBAs

can any on etell me how i can download database hammer or any toll by which i can test my database with number of users ??? thaanks a lott

how to test the db with many users

Thread by: shreesoft00, May 7, 2003, 3 replies, in forum: Performance Tuning for DBAs

hii i have a database server whch right now takes hits from 50 users . now we are moving that db into a envirnoment where users will be min 500 and...

CPU Showing 100% when running Reports

Thread by: shreesoft00, Mar 7, 2003, 14 replies, in forum: Performance Tuning for DBAs

Hi i am running sql2000 on win nt 4.0 i have database which is 9.5 gb in size which is geographically located in defferent location and user...

identity not transfered in snapshot replication

Thread by: shreesoft00, Feb 28, 2003, 1 replies, in forum: Performance Tuning for SQL Server Replication

Hi i am tryin g to replicate a database its working fine but the problem is the identity columns are replicated but not the properties like primary...

HI Changing recovery model from full to simple

Thread by: shreesoft00, Jan 31, 2003, 2 replies, in forum: General DBA Questions

Hiii My transaction log sized to a 6 gb size and the DB was in full recovery model .what i done is i changed the recovery model to simple and...

restoration of databases from 1 servr 2 another

Thread by: shreesoft00, Jan 26, 2003, 2 replies, in forum: General DBA Questions

hi we have 10 databases in one instance and we had taken the backups of all databases including master database . but during restoration to...

how to restrict concurrent connection on sql servr

Thread by: shreesoft00, Jan 23, 2003, 8 replies, in forum: Performance Tuning for DBAs

Hi can we restrict a limited number of concurrent connections to sql servers? how we can do it? anybody can help it as i just want to get 1000...

Wantan netsend alert when a user logins 2 DB urgnt

Thread by: shreesoft00, Jan 21, 2003, 5 replies, in forum: General DBA Questions

hi i have a DB server and i just want an alert when an user logins to the DB through a job definition i have made an operator for net send but i...

unable to connect a sql server on internet

Thread by: shreesoft00, Jan 12, 2003, 5 replies, in forum: General DBA Questions

hi i am unable to connect a server on my local machine i have sql 2000 standard and i have the ip address but its saying server doesnt exist how to...

Transaction log file grown to very large size

Thread by: shreesoft00, Jan 10, 2003, 4 replies, in forum: General DBA Questions

HI i have a produsction database . where i have a very critical database server with atleast 2000 transactions per minute now i am facing a problem...

Error message in profiler

Thread by: shreesoft00, Jan 9, 2003, 8 replies, in forum: Performance Tuning for DBAs

Hi I was Running the profiler and there are only 10 connections on that and suddenly i got a errormessage popped up as "tds buffer length too long"...