but quite oppositely wintel team saying that of ur sqlserver.exe use more sapce it might be problem in file transfer or in any uploads

windows id is created by windows team and by using sql administrator login i created sql login but some times it says unable to connect in this case what...

Hi sir

i run this script in t&d server but memory usage is same and it is increasing

script 1:

sp_configure 'show advanced options',1

reconfigure with override

go

sp_configure...

ya but iwant to survie inthe client location which is now exploring more issues which i might not konw which i am learning from few months so idonw wnt to...

HI

FIRST OF ALL LET U KNOW ABOUT THIS SCRIPT IS FOR MONTHLY ANALYSIS

SO U DO UR NEED FULL ACCORDINGLY

Fisrt u run the below any of the script depens upon...

HI GRANT ,

similar issues occurs in one of our production server if i go into details

1. application team complaining that queries are executing slow and want reason for that...

i mean cpu utilization, or physical IO etc

and another thing

1.what can as a DBA we can look care for performance improvement of a server which is running sqlserver

2....

if u dont mind can u expalin with detaled script

http://www.sqlservercentral.com/Forums/Topic1332796-1549-1.aspx#bm1344627

hai iam a starter in Dba but want post this which might help u

it might be use ful to you if u want to go for testing in...

hi , check this if u feel it 's use full to You

SELECT

TOP 10

[Total Cost]

= ROUND(avg_total_user_cost * avg_user_impact * (user_seeks + user_scans),0)

, avg_user_impact

, TableName = statement...

It may happen even if the user who executed the query in sql server may not closed the query window from long time once if the query window closed then...

ya i too agree with u ALTER TRACE

but if we use default master the user can able to have access on all databases know

i mean it for running...

HI jack

other than giving sysadmin or using this script

-------------------------------------

Use master

Go

Grant Alter Trace to Login

-------------------------------------

1.if we give bulkadmin and public in server role and ddladmin,db_datareader,db_datawriter in database role...

thanks for reply

actually the applications user want to take the data directly from the database instead from application

to which he want to create a stored procedure sp_start_job...

"nothing is better than giving a trail"

try this iam also not sure

give DBCREATOR in serverrole and db_backupoperator in database role

normaly bulkadmin and public are common to non sysadmin

check...