Forum Replies Created
Viewing 15 posts - 2,776 through 2,790 (of 9,244 total)
-
RE: Configuring large memory on a SQL instance
what trace flags do you have set on the service startup?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Performance issue on passive node of sql2k8 cluster.
sp_seeker (11/10/2014)
I have a 2 node(node A and B) cluster with exact same specs. When I failover to node B performance is really bad while everything work fine on...-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Database Owner
cstrati (11/10/2014)
Can you please clarify for me what would happen if the database owner was running as an account which was then disabled?From memory, nothing. If the user were deleted...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: synchronous and asynchronous commit
muthyala_51 (11/10/2014)
We are seeing high number of hadr_sync_wait types on our server after setting up AOAG during peak times. We have setup sync type as synchronous commit and failover automatic....-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: alwayson availability groups- Syncing jobs
New jobs, just script to all replicas at deployment time
Existing jobs, are they really changing that often??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: sql server 2014 installation question
uninstall the CTP release first
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: SSMS Connection via IP issue
where have you looked to obtain the clustered instance IP address?
You may list the VIPs using the following
Get-ClusterResource | ?{$_.ResourceType -EQ "IP Address"} |Get-ClusterParameter network,address,subnetmask | ft ClusterObject,Name,Value
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Log Backup size bigger than Full Backup
yes, run more frequent log backups!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: 2nd instance added should I have used different port
tcronin 95651 (11/7/2014)
not sure if changing the port is that essential or notdepends on the connections to the instance, if you're receiving connections to the instance through a firewall you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: 2nd instance added should I have used different port
You can change the port number in sql server configuration manager and you'll need to restart the sql server services.
The unique combination is on the IP address and TCP port,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Is it pOssible to take the Full backup in Logshipping without Copy only backup
New persopn (11/7/2014)
Hi All,I have configured the log shipping. Is it possible to take the full backup (Not Copy only backup) after configure the log shipping.
Yes of course you may,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: DBCC FREEPROCCACHE resolves my problem but want to know why
TrailRunner (8/29/2014)
From the profiler trace, I noticed there were a lot of Pagelatch_sh wait during the slowness. My research shows that it has to do with database files, table partitioning,...-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: How Mirror server know about application
ALZDBA (11/7/2014)
With SQL2008 (R2 ?) you'll need to modify your connection strings and add the failoverpartner parameter.[assuming your chosen connection library supports the database mirroring parameters
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Max Length of AD Names for Security
SQLJocky (11/6/2014)
Any AD object (account or group) is truncated at 20 characters after the "\".This is what i see on my Windows 2012 server running SQL Server 2014
What OS and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Max Length of AD Names for Security
SQLJocky (11/6/2014)
.if you enter the entire login to the "Z" on the service account, it will fail.Yes of course how silly of me, you make no reference to service accounts...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 2,776 through 2,790 (of 9,244 total)