One of my recent requirement is to provide my client with an 100% high availability solution for SQL Database. Thinking about proposing a Clustering...
its quite late now to give a reply, was quite held in a lot of mess ... yeah we do have OEM to monitor MS SQL through plugin , but the tool is not so...
Hi Brooke, I am not a good developer , i feel that the stored procedure to be very useful, but i get declaration erorrs , when i execute, can you...
Hi, Its SQL job that has netbackup step command's and it runs from a seperate netbackup server, the job duration was found to be around 4 hours and...
Hi all, There is some problems with some of my SQL jobs related with netbackup strergy and applicational pakages as well, that run on sometime quite...
Thanks Preethi..this helps for sure...
Thanks Preethi......if my file groups are split in drive D,G,and S ; and my current tempdb datafile and logfile are present only in S. Do you mean...
Hello All, I do have a database whose size is to the tune of 196 GB, the database has around 28 file groups (one primary and rest ndf files); almost...
Hi Babu, Thanks a lot ,off late I am afraid as Killing the spid may result in Rollback and would make me to restart the SQL services. I am using...
Hello friends, I do have a 'SQL user' who runs a lot of queries that causes performance issues to the database machine. I want to write a query that...
All, Forgot to add I am using SQL2000 Eneterprise edition. Reagrds and thanks Eben
Hi All, Would highly appreciate if any of you can help me with the following as a part of increasing the performance in the database. I want to find...
also forgot to add i am not using a proxy account, will see the registry key...
Server has currently been taken down for maintenance and it may take a couuple of days.... willl analyze this remarkable solution once i get it back...
Satya, I am using Windows authentication only.....and ia m able to access the master server and the other instances from my target machine. Let me...
Hi, I have configured backups through Master target server concept. I have added 8 servers as target servers to my master server. these target...
Hi Frank, Kind of you... Problem is " Table growth statistics collection for all days was enabled for each day " in the server, when I unchecked the...
3rd party tool .. Idera SQl diag tool....... Regards Eben
Thanks satya..it was my application tool that was causing the issue. ..... -- Eben
Thanks for the mail. The server is fine its the SQL serive that gets restarted. On the code that has generated am not abel to understand it...
Separate names with a comma.
